Database – Firebird or MS SQL Server

Due to its architecture, Vertec is relatively independent of the database used. During normal operation, communication with the database server takes place via only a few different SQL commands (SELECT, INSERT, DELETE). Server-specific elements such as stored procedures or views are not used by Vertec.

However, SQL is only limitedly standardized, so there are deviations between different database systems that need to be addressed in Vertec, such as the interpretation of the like Operators for string comparisons or differences in initialization.

Vertec can be operated with the database servers Firebird and MS SQL Server.

Firebird is the database server that comes standard with Vertec and is installed by Vertec Setup. Especially for Vertec updates that require a database conversion, Firebird offers great advantages due to its ease of use. An automatic database conversion (inplace convert) without additional manual work is only supported with Firebird.

For more information on how to run Vertec on Firebird, see the article Firebird.

The use of Firebird is suitable in the following cases:

• Up to 80-100 users or parallel active Vertec logins (concurrent users).
• Medium to large data volumes
• No complex data queries (such as using many or multiple nested subqueries).
• No large amounts of data are migrated to Vertec from the start

Depending on how much and how many of these points are exceeded, the use of Microsoft SQL Server is recommended. To illustrate this: 1500 users cannot be operated with Firebird, while in the case of only 50 users a lot of customizing can be operated and still be set to Firebird.

Operation on MS SQL Server 2005 or later is also supported.

Especially for larger installations, the operation of Vertec on MS SQL Server is more efficient. See the article Performance on the Net.

Vertec does not deliver and cannot support MS SQL Server. The customer must provide a ready-to-use MS SQL Server including Management Studio.

All information about running Vertec on MS SQL Server can be found in the article MS SQL Server .

The use of MS SQL Server is suitable in the following cases:

• With more than 100 users and/or many parallel active Vertec logins (good scaling).
• Large amounts of data
• Complex database queries, which are characterized, for example, by the use of many or multiple nested subqueries.
• Large amounts of data are migrated to Vertec right from the start

Configuration of the database interface is done via the Database section in the Vertec.ini file. By default, Vertec reads the Database section in the Vertec.ini file at startup, but alternative database sections can also be specified in the same file.