Changing the server database location

You can configure the Helix ALM Server to use a different database. For example, you can change the database if you move it to another computer or experience problems and want to use a backup copy of the database. You should not need to frequently change the server database.

Note:  When you start the 64-bit Helix ALM Server for the first time, a native SQLite server database (ttserv.db) is automatically created if one does not exist.

1. Make sure you are logged in to the server to change. Choose File > Connect to Server to connect to a different server.

2. Click Server Options. You can also choose View > Server Options.

The Options dialog box opens.

3. Select the Server Database category.

4. Click Change.

The Helix ALM Server Database Configuration dialog box opens.

5. Select a Database Type. The available fields change depending on the selected type.

6. Enter the Connection Information.

You are not prompted for connection information or to test the connection if you are changing to Helix ALM native format. The server automatically points to the database in the Helix ALM database directory on the server computer.

7. Click Test to test the connection.

The Test Connection dialog box opens and displays the results. If the test connection fails, you can copy and paste the text into an email or text file and send it to your DBA for help.

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

You return to the Helix ALM Server Database Configuration dialog box.

9. Click OK to change the database location.

The following information is verified if you selected an RDBMS database:

• The specified connection information leads to a valid RDBMS.
• A Helix ALM Server application is not configured for the selected server database.
• All of the required database tables exist and are accessible.

10. You return to the Options dialog box. Click OK to apply the changes.

You must stop and restart the Helix ALM Server to complete the process.