Moving Surround SCM and SQL Server Databases Between Computers

This article explains how to move Surround SCM and SQL Server databases from one computer to another. Ask your DBA for help with backing up, creating, and restoring SQL Server databases.

Back up the source SQL Server databases

Create a backup of the Surround SCM Server database and any other SQL Server databases you want to move to the destination computer, such as databases that only host mainline branches.

Note: The server database contains data source names (DSNs) for mainline-only RDBMS connections, which can only be used by one Surround SCM Server at a time. If you want to use the same DSNs on the destination computer, no additional backup steps are required. If you want to move a mainline-only database and use a different DSN on the destination computer, you must remove the RDBMS connection and all its mainline branches from Surround SCM before backing up the database. Refer to the Surround SCM User Guide for information about removing RDBMS connections and mainline branches.

Install the Surround SCM Server and SQL Server on the destination computer

Run the Surround SCM installer on the destination computer and install the Surround SCM Server as a service. The same Surround SCM version must be installed on both computers. When you are prompted to set the server database connection, select ODBC- SQL Server as the type and enter the DSN to use for the server database.

Create empty SQL Server databases on the destination computer

Create one database for the server database and one database for each additional mainline-only database you are moving.

Restore the databases from the source computer to the new SQL Server databases on the destination computer

Create DSNs for the restored databases

Use the Microsoft ODBC Administrator to create DSNs for each database. The server database DSN must match the DSN entered during Surround SCM installation. If you did not remove other RDBMS connections and mainline branches from the source Surround SCM Server, DSNs for mainline-only databases must match the DSNs used on the source computer.

Configure the Surround SCM Server database on the destination computer

Use the following steps to configure the server database.

Start the Seapine License Server if it is not running.

Start the Surround SCM Server service if it is not running.

Start the Surround SCM Client, configure a connection to the new server, and log in to it. You are prompted to configure the database location.

Click Yes. The Connection information dialog box opens.

Select ODBC as the Connection Type and enter the server database connection information. If you use Windows authentication in the ODBC connection, you can leave the username and password fields empty.

If you used the same DSNs on both computers for mainline-only databases, the RDBMS connections are automatically added to Surround SCM when the server database is configured and no additional steps are needed. If you used different DSNs, you must create RDBMS connections to the mainline-only databases in Surround SCM and add the existing mainline branches to the new server. Refer to the Surround SCM User Guide for information about adding RDBMS connections and existing mainline branches.

Schedule a Demo

Thanks! We received your demo request and will be in touch soon to schedule it.

Try TestTrack Today

Request your 30-day TestTrack free trial and experience how it can put you in complete control of the product development lifecycle, from requirements definition through testing. Your evaluation includes free technical support.

Thanks! We have emailed you your evaluation serial key.

Try QA Wizard Pro Today

Evaluate QA Wizard Pro for 30 days to see how it can help with your automated testing needs.

Your 30-day evaluation includes:

999-user license to record and play back functional test scripts

Five-virtual-user license to record and play back load test scripts

Free, unlimited access to customer support

Access to how-to videos, user guides and other educational content

Thanks! We have emailed you your evaluation serial key.

Try Surround SCM Today

Evaluate Surround SCM for 30 days to see how it will help with software change management and version control throughout your organization. Your evaluation includes free technical support.