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 migration when the Firebird database size approaches 1 GB.
Supported database types
OpenLM supports the following external database types: MS-SQL Server, Firebird Server, and MySQL. The OpenLM Data migration tool may migrate between any of these Database types to any other type (e.g. from the default embedded Firebird to the external MS-SQL Database).
Where do I get the OpenLM Database migration tool from ?
The OpenLM Database migration tool is not part of the standard OpenLM software package. Please contact OpenLM’s sales department firstname.lastname@example.org in order to obtain a copy of this software.
Possible migrations types:
The possible database migration formats are as elaborated in the following table:
Source database Destination database
SQL Server SQL Server
MySQL SQL Server
Firebird SQL Server
SQL Server MySQL
SQL Server Firebird
The machine running the database migration process needs to comply with the following minimal hardware and software requirements:
64 bit Windows 7/8/10 or Windows Server operating systems.
Allocated storage space should be triple the size of the original database (Necessary only during the migration process itself)
Prior to applying any changes to the OpenLM database, stop the “OpenLM Server” service, and backup the active database.
The migration process may be quite lengthy and time consuming. You may consider running it on the target database machine, to avoid network delay. In that case, you will need to apply the above to the machine hosting the target database, and have a local copy of the source database there.
When migrating a default Firebird database to another database type (e.g. MS-SQL), download and install the latest version of the Firebird Server 2.5 on the source Firebird database machine.
Make sure your OpenLM license enables data migration: In the EasyAdmin web application click ‘Start’ → ‘Administration’ → “OpenLM License”, and ensure that your preferred external database entry (DB_Firebird, DB_MS-SQL, DB_MySQL) is available, and the quantity is non-zero. If otherwise – please contact the OpenLM Sales department to arrange for such a license.
Create a blank destination database.
The user running the database migration tool must possess administrative read / write privileges on the destination database.
In case of migration to MS SQL Server, shrink the destination database, as explained in the documentation here.
It is recommended to set the target database to be case sensitive.
If are also using the OpenLM Reporting Hub on the same machine, then you should make sure to remove the variable “KETTLE_HOME” from your environmental variables.
For MySQL databases, please run the script line:
SET SQL_SAFE_UPDATES = 0;
in order to avoid the “1175 you are using safe update mode …” error message.
Upgrade your OpenLM system to the latest version available. Please consult the following documents.
For embedded Firebird databases:
Upgrade guide to Version 3: Embedded Database – AN4101a
For external databases:
Upgrade guide to Version 3: External Database – AN4101b