Database Convert

If a Vertec Update to be performed, the database must be converted to the new version.

As of Vertec version 6.6, updating Vertec across several Vertec versions is no longer supported. To update to Vertec version 6.6, a Vertec version of 6.5 is required (see also: Can I update older versions directly? ). This conversion is done with the Vertec Database Konvert (DB Konvert).

With DB Konvert it is also possible to copy Firebird databases to a Microsoft SQL database and vice versa. A conversion is possible

• from MS SQL to MS SQL
• from MS SQL to Firebird
• from Firebird to Firebird
• from Firebird to MS SQL

DB Konvert is able to copy any existing customer-specific indexes, so they will be available in the new database even after conversion.

Automatic convert with Firebird

When using Firebird databases, the conversion can be done automatically when updating Vertec.

When starting Vertec with a new database version, the DB Konvert dialog appears:

Click Yes to start the automatic conversion. A status bar shows the progress of the conversion.

After completing the process, the Vertec Desktop App must be restarted once:

Manually convert with Microsoft SQL Server

To convert a Vertec database with MS SQL Server, a temporary database must be created on the SQL Server.

This can be done via the Copy database task described below or alternatively by creating a new empty database and importing a backup.

• Open Microsoft SQL Server Management Studio and right-click on the current Vertec database. In the dialog that appears, select Window Tasks > Copy Database...
• A wizard will appear to assist you in backing up the database:
  • Under Source Database specify the appropriate database. The backup type is Full , the backup is not selected.
  • Select Destination Hard disk and specify the file name with the Add button. Remove all other entries.
• With the right mouse click select Recover files and file groups... .
  • Destination to recover, in Database : Directly specify the name of the temporary database to be created.
  • Specify the source for the recovery, from medium : backup file. Check the box below for the backup set to be recovered.
• Once this process is completed, click Close and restart Microsoft SQL Server. The temporary database is now visible.

Perform Manual Convert

Start Vertec with the Parameters /DC . The conversion dialog opens:

The Target Database field should already be initialized with the default Vertec installation setting and point to the Vertec database of the SQL Server.

For the data of Quell Datenbank copy the contents of the field Ziel Datenbank and set Initial Catalog = vertectemp (or the name of the temporary SQL Server database created)

Manual conversion changes the source database, so create a backup if necessary.

By pressing the Start Buttons first delete the tables in the target database and then create them. Then the data from the Vertectemp database is copied to the Vertec database and converted to the new version.

After conversion, the Vertec Desktop App has to be started once. The temporary database vertectemp is no longer needed and can be deleted.

Copying Databases

DB Konvert can be used to copy Vertec databases. It is also possible to copy a Firebird database to a Microsoft SQL database and vice versa.

The procedure corresponds to manual conversion:

• Start Vertec with the /DC parameter.
• As the source database, select the database that you want to copy.
• Enter an empty Firebird or MS SQL database as the target database.

The following information is required:

Example:

ServerName = MYSERVER:C:\Programme\Vertec\DB\Vertec.fdb

User Name = SYSDBA

Password = US-bVTkvBqrtWV+Z

Example:

Provider = SQLOLEDB

Data Source = MYSERVER

Initial Catalog = vertec

User ID = Vertecuser

Password = UDQsK8owKnIwIF+Z

Then you can select whether only the database schema should be created or whether the data should also be copied:

With one click on Start starts the database convert. The progress is shown in a status bar.

After the conversion is complete, enter the information about the copied database in the Vertec.ini – File and restart Vertec.

Error converting Firebird to SQL Server

Converts from Firebird to SQL Server may result in error messages such as value out of bounds or Invalid character value for cast specification come.

This may be due to invalid date values in the source database. Firebird and MS-SQL Server accept different ranges of date values: Firebird can handle date values from 01.01.0001 to 31.12.9999, MS-SQL Server accepts values from 01.01.1753 to 31.12.9999.

If, for example, a date of the form 12.01.1000 is accidentally saved in a Firebird database, this results in an error message during data conversion to MS-SQL Server.