Changing the server database location

You can configure the Surround SCM Server to use a different database. For example, you may need to point to the server database to a new location after moving it or use a backup copy of the database if you experience problems. You should not need to frequently change the server database.

1. Make sure you are logged in to the server to change.

2. Choose Tools > Administration > Server Options.

The Server Options dialog box opens.

3. Select Server Database from the General Server Options category.

4. Click Change.

The Surround SCM Server Database Connection dialog box opens.

5. Select a Connection Type.

6. Enter the Connection Information. The fields displayed depend on the selected connection type.

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 Surround SCM Server Database Connection dialog box.

9. Enter the Minimum number of connections and Maximum number of connections to specify the smallest and largest number of connections that will be allowed in the database connection pool.

10. Click OK to change the database location.

The following information is verified:

• The specified connection information connects to a valid RDBMS.
• A Surround SCM Server application is not already configured for the selected server database.
• The database is in the current format. If it is in an older format, you are prompted to upgrade it. Click Yes to upgrade the database.
• The database contains the required tables and the tables are accessible. If the database does not contain any Surround SCM tables, you are prompted to create them. See Creating Surround SCM database tables.

11. You return to the Server Database category. Click OK to apply the changes.