USA +1 866 806 2068 | UK +44 203 1292 513 | JAPAN +81 3 45208991 担当:萩原 info@openlm.com

Data Migration Tool – AN3025a

The OpenLM Data Migration tool enables OpenLM customers to transfer OpenLM information between different databases. It facilitates the migration of the default OpenLM Firebird database information to either MS-SQL, Oracle or MySQL.

SUPPORTED DATABASES:

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

SYSTEM REQUIREMENTS:

Microsoft Windows 7,  Windows 8, Vista, Server 2003, Server 2008, Server 2012.

Microsoft .NET Framework 3.5.

WHERE DO I GET THE DATABASE MIGRATION TOOL FROM ?

The OpenLM Database migration tool is not part of the standard OpenLM software package. Please contact OpenLM sales’ department  sales@openlm.com in order to obtain a copy of this software. Install the OpenLM Data Migration Tool using the supplied EXE file.

Preparations

For elaborate examples of the preparations required to run the Database migration tool, please refer to these documents:

Application Note 2008b: OpenLM database migration, from Firebird 1.7 to MS-SQL 1.8 (via Firebird 1.8)

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

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:

  • Create a specific database/schema for OpenLM tables in the destination database.

  • 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

The following is a demonstration of an Embedded Firebird to MS-SQL Server migration. The process is very similar for the other options.

1. Stop the OpenLM server service

2. Copy the OpenLM database to a different directory (e.g.: C:\tmp\).

the default location is C:\Program Files (x86)\OpenLM\OpenLM Server\db\

3. Launch the tool using the following path,  from Windows Start → All Programs → OpenLM Data Migration tool

v1

4. Select the Firebird database by clicking the radio button. A dialog window opens:

v2

5. Type in the full path to the database file (*.FDB). (e.g.: C:\tmp\)

6. Fill in the Username & Password

The default OpenLM user name is sysdba, and the password is masterkey.

7. Check the Embedded checkbox, and click OK. The tool will connect to the database and a message will appear announcing the connection status

8. Specify the destination database type, e.g.:  MS-SQL Server:

v3

9. Select the Authentication mode: Windows Authentication or SQL Server Authentication.

In this example we applied the Integrated Security option for Windows Authentication. In order to apply SQL Server Authentication, uncheck the Integrated Security box and enter the 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.

10. Click the Transfer button. The application will transfer all the information from the source database to the destination database.

After the data has migrated, use the OpenLM Database Configuration form to set the OpenLM Server to use your new database:

Application Note (3025) OpenLM v2.0: OpenLM Database Configuration Form