Converting the server database to a different type

You can convert the server database to PostgreSQL or SQL Server format. Any mainline branches stored in the same RDBMS database instance as the server database are also converted to the new instance.

Keep the following in mind before you start the conversion:

  • All users must be logged out of the Surround SCM Server.
  • The destination database cannot be in use by another server.
  • All of the tables in the destination database must be empty except for the serverid, ownerlck, and RDBMSOptions tables.
Surround SCM can automatically create the server database tables initialized with default data during the conversion. See Creating Surround SCM database tables.

1. Make sure you are logged in to the server to convert the database for.

2. Choose Tools > Administration > Server Options.

The Server Options dialog box opens.

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

4. Click Convert.

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 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 convert the database.

The conversion information is sent to the server for validation.

  • If the validation is successful, you are prompted to start the conversion. Remember that users cannot log in during the conversion process.
  • If the validation fails, make sure the server tables exist and are empty, except for the serverid, ownerlck, and RDBMSOptions tables. You should also make sure that another server is not using the database.

11. Click Yes.

The conversion starts. The Conversion Status dialog box opens.

12. Click Close when the conversion finishes. You are prompted to use the converted server database.

13. Click Yes. You must stop and restart the server to before users can access files.

You can also manually change the database the server is using. See Changing the server database location.