Creating a new external OpenLM databases (e.g. MS-SQL, MySQL) - KB4101e - OpenLM Software License Management
Israel +972 4 6308447         USA +1 619 831 0029              JAPAN +81 505 893 6263 担当:萩原

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

You are here:
< All Topics

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, collated case insensitive.

3. Run the OpenLM Database Upgrade tool  (Windows Start –> OpenLM –> OpenLM Database Upgrade). This will produce the OpenLM tables within the external database.

4. Run the OpenLM Database Configuration tool (Windows Start –> OpenLM –> OpenLM DB Configuration), and point it to the external database you have just created.

Previous Connect to a New External Database – SQL Server Database – HT812
Next FAQ – Upgrading to OpenLM Server v5
Table of Contents