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

By default, OpenLM provides an embedded Firebird database as part of its basic installation.

Customers may want to migrate their tables to an external database, when they become too large for the embedded database to handle. OpenLM recommends considering a database migration when the database size approaches 1 GB.

Supported database types

OpenLM supports the following external database types: Oracle, MS SQL Server, Firebird Server, and MySQL. Data migration is performed by the “Data migration tool”, from the default embedded Firebird to any of the four external database types.

Where do I get the OpenLM Data migration tool from ?

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

This Application note refers to the OpenLM Database migration version 3.0. Make sure you are working with the latest OpenLM Database migration tool.

Migrating the OpenLM embedded Firebird database to Oracle

1. Prior to any change made on the database, is is imperative to stop the OpenLM Server service, and back up the OpenLM Firebird database. This database is normally located at:

C:\Program Files (x86)\OpenLM\OpenLM Server\db

2. Open the Oracle SQL Developer tool, and create an Oracle user (e.g. MYUSER). The user name should be preceded with C##. Here is an example for a user creation code:
— USER SQL
CREATE USER c##_
MYUSER IDENTIFIED BY <password>
DEFAULT TABLESPACE “USERS”
TEMPORARY TABLESPACE “TEMP”;

— QUOTAS
ALTER USER c##_MYUSER QUOTA UNLIMITED ON USERS;

— ROLES
GRANT “RESOURCE” TO c##_MYUSER;
GRANT “CONNECT” TO c##_
MYUSER;
GRANT CREATE SESSION to c##_
MYUSER;

3. Open the “Data migration tool”, and select the source ‘Firebird’ database. The Firebird Database Credentials dialog opens.

  • Type in the Current Firebird database path
  • The Firebird username is ‘sysdba’
  • The Firebird password is ‘masterkey’
  • Click OK.

4. Type in the ‘Target’ Oracle server name (or IP), and select the ‘Oracle’ radio button. The Oracle Database Credentials dialog opens. Type in the required information:

  • Oracle serrvice: orcl
  • Port number: 1521 by default.
  • Username and Password – as created by the user creation script above.

5. Click the ‘Transfer’ button. The Firebird database is now being migrated to Oracle.

6. In order to work with the newly created Oracle database, Open the “OpenLM Database configuration tool” (Windows’ start → All programs → OpenLM → Server → OpenLM database configuration), and point to it. An additional stop+start of the  OpenLM Server service may be required.

Migrating the OpenLM embedded Firebird database to MS-SQL Server

1. Prior to any change made on the database, is is imperative to stop the OpenLM Server service, and back up the OpenLM Firebird database. This database is normally located at:

C:\Program Files (x86)\OpenLM\OpenLM Server\db

2. Download and Install the latest OpenLM Server version. This will upgrade the current OpenLM Firebird database to the latest version.

3[a]. Open the “Data migration tool”, and select the source ‘Firebird’ database. The Firebird Database Credentials dialog opens.

  • Type in the Current Firebird database path
  • The Firebird username is ‘sysdba’
  • The Firebird password is ‘masterkey’
  • Click OK.

4. Type in the ‘Target’ MS-SQL server name (or IP), and select the “MS SQL Server” radio button. The MSSQL Database Credentials dialog opens.

5. Type in the required information:

  • Select either “integrated security” or “SQL express” credentials
  • Username and Password of the MS-SQL database user.
  • Click the “Test connection” button

6. In the ‘Databases’ combo box, you can either:

6a. Type in the name for the MS-SQL database. This will create an empty MS-SQL database which is equivalent in it schema to your Firebird database, or

6b. Select an existing empty MS-SQL database name from the drop down menu.

After that – click ‘OK’.

7. Click the ‘Transfer’ button. The Firebird database is now being migrated to MS-SQL .

8. In order to work with the newly created MS-SQL database, Open the “OpenLM Database configuration tool” (Windows’ start → All programs → OpenLM → Server → OpenLM database configuration), and point to it.

9. An additional stop+start of the OpenLM Server service is required.

Migrating the OpenLM embedded Firebird database to MySQL

The process of migrating the Firebird DB to MySQL is similar to that of the MS-SQL server database, described above:

1. Stop the OpenLM Server service, and back up the OpenLM Firebird database, normally located at:

C:\Program Files (x86)\OpenLM\OpenLM Server\db

2. Download and Install the latest OpenLM Server version.

3. Open the “Data migration tool”, and select the source ‘Firebird’ database. The Firebird Database Credentials dialog opens. Fill in the required textboxes.

4. Type in the ‘Target’ MySQL server name (or IP), and select the “MySQL Server” radio button. Type in the required information:

  • MySQL port number
  • Username and Password of the MySQL database user.
  • Click the “Test connection” button

5. In the ‘Databases’ combo box, you can either:

5a. Type in the name for the MySQL database. This will create an empty MySQL database which is equivalent in it schema to your Firebird database, or

5b. Select an existing empty MySQL database name from the drop down menu.

After that – click ‘OK’.

6. Click the ‘Transfer’ button. The Firebird database is now being migrated to MySQL .

7. Open the “OpenLM Database configuration tool” (Windows’ start → All programs → OpenLM → Server → OpenLM database configuration), and point to the new MySQL database.

8. An additional stop+start of the OpenLM Server service is required.