Guide to OpenLM Database Migration Tool

General

The purpose of OpenLM Data Migration Tool is to allow OpenLM customers to transfer OpenLM information between different databases. The tool supports four types of databases and allows the migration of OpenLM information between them.

For elaborate examples of the Database migration tool’s functionality, please refer to these documents:

Application note 1008: OpenLM database migration, from Firebird 1.7 to MS-SQL 1.7

Application Note 2008a: OpenLM database migration, from Firebird 1.7 to MS-SQL 1.8

Application Note 2008d: OpenLM database migration, from Firebird 1.7 to Oracle 1.8

Supported databases: Oracle, MS SQL Server, Firebird Server, Firebird embedded (OpenLM default storage).

System requirements: Microsoft Windows XP, Vista, Server 2003, Server 2008. Microsoft .NET Framework 3.5.

How to get it? Contact OpenLM sales department sales@openlm.com.

Installation: Install OpenLM Data Migration Tool using the supplied EXE file.

Preparations

Prepare the source database:

• Consult OpenLM Support regarding the available migration release.
• Stop your OpenLM Server.
• Backup source Database.
• Upgrade Database if there is a need.

Prepare the destination database:

• It is recommended to create a specific database/schema for OpenLM tables.
• It is also recommend to create a specific DB user with access rights only to OpenLM’s database/schema. Use this specific user to perform all tasks elaborated in this document.
• Use OpenLM DDL scripts to create the database structure in the destination database.

Operation

Launch the tool from Start->All Programs->OpenLM Data Migration tool

We will demonstrate the operation by doing an Embedded Firebird (Default OpenLM DB) to MS SQL Server migration.

Select the Firebird database by clicking the radio button. A dialog will open:

Select the database file from the disk (*.GDB), use OpenLM username and password and mark the embedded check box (Contact OpenLM support for full connection string).

Then click OK, the tool will try to connect to the database and will pop a message with the connection status.

Then specify the destination database type. In this example – MS SQL Server:

In this example we used the “Integrated Security” option (for using “Windows Authentication”). If you use “SQL Server Authentication”, uncheck the “Integrated Security” and enter UserID and Password.  After clicking “Test Connection”, the application will populate the Databases combo box. Select the destination database from the list and click OK. OpenLM will pop a message that will indicate if the application managed to connect to the database.

After that, click “Transfer”. The application will transfer all the information from the source database to the destination database.

After the data was migrated, use OpenLM configuration form to set OpenLM Server to use your new database.