How to Move a StarTeam Repository with MS SQL



How to Move a StarTeam Repository with MS SQL


Information in this Brief applies to:

  • StarTeam Server 3.x, 4.x
  • MS SQL 6.5, 7.0


Moving a StarTeam repository requires special setup steps to ensure that the cipher phrase and DSN have been entered or created on the target system. To complete a successful move, please be aware:

  1. You need to know the cipher phrase for the repository.
  2. You need to install StarTeam Virtual Team server on the target system.
  3. Be certain which database you are using with the repository.
  4. Be aware of any foreign archives the repository is using.
  5. If you have been running STVTS as an NT service, previous to the move, change it back to run as an application.(The cph and scg files should be copied after the change.)
  6. If possible, carefully test the newly ?moved? configuration before deleting the old.

More Information

Copying the repository items:

  1. Stop the StarTeam server on the old machine.
  2. Copy the repository directory to the new computer or hard drive. Try to maintain the same same directory structure. If the directory structure has changed for the repository on the new machine, you will have to update the StarTeam .scg before running the StarTeam server. See Running the server for the first time.
  3. Copy the configuration file and cipher file in the StarTeam Virtual Team Server Config Files directory to the new StarTeam Virtual Team Server Config Files directory.
    C:\Program Files\StarTeam VirtualTeam Server 4.0\Config Files\DEMO.SCG
    C:\Program Files\StarTeam VirtualTeam Server 4.0\Config Files\DEMO.CPH

Manually recreating the ODBC connection on the target system:

  1. Start the StarTeam Virtual Team Server.
  2. Select the repository you wish to start.
  3. Click on the Properties button.
  4. To the right of the Cipher name box click on the Verify Button.
  5. Enter the cipher key that was used to create the repository.
  6. Click on the Database tab.
  7. Highlight the entry in the DSN box.
  8. Hold the Ctrl key and hit the C key on the keyboard. This will copy the name entry to the clipboard.
  9. Click on the OK button.
  10. From the Start button at the bottom lower left of the desktop, go to Setting and select the Control Panel.
  11. From the Control panel select the ODBC icon.
  12. In the ODBC controls select the System DSN tab.
  13. In the ODBC System DSN tab click on the Add button.
  14. Scroll down the list of Create New Database source and select the appropriate database driver. Click on the Finish button.
  15. Move your pointer to Data Source Name box and click. Hold the CTRL key down and hit the V key on the keyboard this should paste the DSN name from step 9 and 10.
  16. You can enter any useful information in the description box if you wish.
  17. Select SQL Server.
  18. Ctrl V in the DNS Name box.
  19. Enter the description for the System DSN.
  20. Select the SQL Server where you created the SQL database.
  21. Leave the Network Address and Library box as (Default).
  22. Click on the Option button.
  23. In the Database name box Select the SQL database for StarTeam and Click on the OK button.
  24. Also place a check mark in the box on the following items:
    "Use ANSI quoted Identifiers"
    "Use ANSI nulls, padding, and warnings"Note: If your ODBC MS SQL driver does not support "Use ANSI quoted Identifiers" or "Use ANSI nulls, padding, and warning" please update the MS SQL ODBC drivers.
  25. In the ODBC Data Source Administrator click on the OK button.
  26. Move your pointer on the Red box in the System Tray, select server configuration Menu appears.

Running the server for the first time:

If you have moved the repository to a different directory or hard drive letter other than the original creation setting please use the following steps:

  1. Click on the StarTeam VirtualTeam server icon and launch the "select server configuration" dialog box.
  2. Select the server configuration you would like to start, and select the properties button.
  3. Set the new path for the Server startup log path.
  4. Select the check box "View server configuration before server starts", and then click OK.
  5. Start the StarTeam server configuration.
  6. Enter user logon and password.
  7. In the StarTeam VirtualTeam Server Configuration dialog box on the General Tab in the Attachments Box make sure that the path is pointing to the new location.
  8. In the StarTeam VirtualTeam Server Configuration dialog box, on the Vault Tab, make the sure that the following items are pointing to the correct directory:
    Vault Path
    Disk Cache Path
    Archive Path
Old KB# 28386
Comment List