Microsoft SQL Server Database Upgrade Paths

You should follow one of the upgrade paths listed below to upgrade your Microsoft SQL Server database. These are steps at a high level and you should familiarize yourself with the remaining upgrade and database requirements provided in this Installation Guide. You can also find more information about migrating server configurations and Microsoft SQL Server database backups in the Administration Tool Help.
Important: We strongly recommend that you preform a full backup of your database before upgrading or migrating to the new database. A full database backup creates a duplicate of the data that is in your existing database.

Migrating a Server Configuration

Use the Server Administration tool to migrate from a database to any other database support by the Server.

  1. Open the Server Administration tool by clicking Start > Programs > Micro Focus > StarTeam Server <version> > StarTeam Server.
  2. In the list of servers, select the server you want to migrate.
  3. Select Actions > Migrate from the main menu.

    This migrates the repository to the database running a supported version of Microsoft SQL Server.

  4. Start the Server by selecting Actions > Start Server from the main menu.
  5. Click Server > Configuration Properties from the main menu to verify the server configuration database connection settings.
  6. Upgrade to the new release of StarTeam.

Backing Up and Restoring a Database

  1. Back up the database running on the old Microsoft SQL Server version and restore the copy onto the database running the new version of Microsoft SQL Server.
  2. Open the Server Administration tool by clicking Start > Programs > Micro Focus > StarTeam Server <version> > StarTeam Server.
  3. In the list of servers, select the server you want to upgrade.
  4. Click Server > Configuration Properties from the main menu and update the configuration settings to point to the new database connection on the server.
  5. Start the Server by selecting Actions > Start Server from the main menu.
  6. Upgrade to the new release of StarTeam.