Created On:  20 January 2011

Problem:

What steps are necessary to upgrade a StarTeam database from SQL 2005 Express Edition to SQL Server 2005 Enterprise Server?

Resolution:

It is best practice to complete these on a test environment before applying to your production systems.

1. Stop the current StarTeam configuration
2. Take a backup of the SQL 2005 Express Edition database
3. Restore the backup on to the SQL Server 2005 Enterprise Server
4. Change the DSN to point to the SQL Server 2005 Enterprise Server database and verify the connection 
5. Use the Star Team Administration console to confirm that the StarTeam can connect to the SQL Server Enterprise database
6. Start the StarTeam configuration

Please contact Micro Focus StarTeam support for further guidance.
Incident #2496218