Search:     Advanced search

Moving Surround SCM and PostgreSQL Servers Between Computers

Article ID: 718  |  Last updated: 22 Dec, 2014

This article explains how to move Surround SCM and PostgreSQL databases from one server computer to another using the pgAdmin III tool. pgAdmin is automatically installed with PostgreSQL on Windows. If you use Mac OS X or Linux, download pgAdmin after installing PostgreSQL.

Back up the source PostgreSQL database

Create a backup of the Surround SCM Server database and any other databases that host mainline branches you want to move to the destination computer. See Backing Up Surround SCM 2009 and Later Databases.

Install the Surround SCM Server and PostgreSQL on the destination computer

Run the Surround SCM installer on the destination computer to install the Surround SCM Server and PostgreSQL. An empty PostgreSQL database is automatically created.

Note: Do not start the Surround SCM Server.

Restore the source PostgreSQL database to the destination computer

  1. Start pgAdmin.
  2. Double-click the local PostgreSQL server in the Object Browser to connect to it. You may be prompted to enter the PostgreSQL password. The default password is s34p1n3.
  3. Expand the Databases node and select the new database that was automatically created.
  4. Choose Tools > Restore. The Restore Database dialog box opens.
  5. Enter the Filename for the server database backup file to restore or browse to it.
  6. Click OK. The data is restored in the new database.
  7. Click Cancel to close the Restore Database dialog box.
  8. If you want to restore additional databases, select the Databases node in the Object Browser and choose Edit > New Object > New Database to create a new database to restore to.
  9. Repeat steps 4 - 6 for each mainline branch database you want to move to the new server.

Configure the Surround SCM Server database on the destination computer

  1. Start the Seapine License Server if it is not running.
  2. Start the Surround SCM Server.
  3. Start the Surround SCM Client, configure a connection to the new server, and connect to it. You are prompted to configure the database location.
  4. Click Yes. The Connection Information dialog box opens. Information for the restored database is displayed.
  5. Click OK. You are prompted to reconfigure the server database.
  6. Click Yes and restart the Surround SCM Server.

Create RDBMS connections and add existing mainline branches to the destination server

If you moved other databases to the destination computer, you must create RDBMS connections to them in Surround SCM and add the existing mainline branches to the new server. Refer to the Surround SCM help for information about adding RDBMS connections and restoring RDBMS mainline branches to a different server.

Article ID: 718  |   Last updated: 22 Dec, 2014
database server application PostgreSQL

Prev   Next
Setting Surround SCM View/Edit File Options     Surround SCM ERDs