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

Creating a new external OpenLM databases (e.g. MS-SQL, MySQL) – AN4101e

Scope

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.

Customers may also choose to start off with an external database, and not to bother with the data migration later.

These two motivations require a preparation of an OpenLM 3 schema for the external database.

Procedure

The procedure of preparation of an External empty database schema for MS-SQL and MySQL is similar, and consists of the following stages:

1. Download and Install the latest OpenLM Server version. This will create a Firebird database.

2. Open the Microsoft SQL Server Management studio, and create a new empty MS SQL database.

3. Run the “Upgrade OpenLM database from earlier versions” tool  (Windows’ ‘Start’ –> All programs –> OpenLM –> Server –> tools). This will produce the OpenLM tables within the External database.

4. Open the OpenLM database configuration tool (Windows’ ‘Start’ –> All programs –> OpenLM –> Server –> OpenLM database configuration), and point it to the external database you have just created.