Using databases with Hot-Standby.
1) Introduction Hot-Standby is an E3 feature that allows implementing of the concept of fail-over in a supervisory system. This means you can have two servers running simultaneously: the main…
Category: DataBases
Stored Procedures.
Although E3 already has objects like queries that simplify manipulation of database records, we can improve its performance creating subroutines…
Autor
Renato Souza
Migrating Access databases to SQL Server 2005.
This article illustrates how to migrate from an Access database directly to an SQL Server. SSMA is a tool provided by Microsoft that converts Access database objects into SQL Server…
Connecting E3 to an Oracle database.
1) Introduction To connect an Oracle database server to E3 you have to install and configure an Oracle client x86 software program, through which the connection is performed. This article…
MSDE – A free alternative to MS SQL Server.
,NOTE: We currently recommend SQL Server Express instead of MSDE as a free alternative to SQL Server. 1) Introduction In other articles, we have discussed the technical advantages of using…
Using MS SQL Server as Database in Elipse E3.
Introduction The use of relational databases involves installing and administering them. However, it is not always possible to have these features available at the time of testing or implementing a…
Introduction to databases in E3.
1) Introduction The goal of this article is to illustrates concepts about the different databases available in the market. A brief introduction will be presented regarding concepts related to databases…
Using Oracle databases from Elipse E3.
1) Introduction In a supervisory system, we work with different variables and information that need to be stored for future reference or for future reference in searches and comparisons, in…