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 or MySQL versions starting with 2012.
MS SQL Server, Firebird Server, Firebird embedded (OpenLM default storage).
Microsoft Windows 7, Windows 8, Vista, 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 firstname.lastname@example.org in order to obtain a copy of this software. Install the OpenLM Data Migration Tool using the supplied EXE file.
For elaborate examples of the preparations required to run the Database migration tool, please refer to these documents:
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.
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
4. Select the Firebird database by clicking the radio button. A dialog window opens:
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:
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: