Converting the server database

You can convert the license server database to a different RDBMS type. SQLite, ODBC - SQL Server and PostgreSQL are supported.

Keep the following in mind before you start the conversion:

  • The database you are converting to must be created before the conversion (except SQLite).
  • All tables in the physical database must be empty (except SQLite).
  • The database you are converting cannot be in use by another Helix ALM application or another license server.
  • All other users must be logged out of the license server and admin utility.
  • Hard drive crashes or conversion errors can result in data loss. It is important to back up the server database regularly. See Backing up the license server database.
If you are converting to ODBC - SQL Server, we recommend that you manually create the server database tables. The license server can also create the tables during the conversion. See Automatically creating Helix ALM License Server tables.

1. Make sure you are logged into the license server to convert the database for. Choose File > Connect to Server to connect to a different server.

2. Click Server Options.

The Server Options dialog box opens.

3. Select the Server Database category.

4. Click Convert.

The License Server Database Conversion dialog box opens.

5. Select a Database type.

6. Enter the Connection Information.

The available fields change based on the selected database type.

You are not prompted for connection information or to test the connection if you are converting to SQLite. The database is automatically converted into the C:\Program Files\Perforce\License Server\LicenseServDb directory.

7. Click Test to test the connection.

The Test Connection dialog box opens and displays the results.

If the test connection fails, contact your DBA or internal support department for help.

8. Click OK to close the Test Connection dialog box.

9. Click OK to convert the database.

You are prompted to start the conversion.

10. If you want to use the converted database immediately after the conversion finishes, select Use converted database.

If you do not select this option, you can manually change the database the license server is using after the conversion. See Changing the server database.

11. Click Yes.

The Conversion Status dialog box opens and the conversion starts.

12. Click Close when the conversion finishes.

13. Stop and restart the license server to complete the conversion process.