Upgrade from SQL Server 2000 to 2005

kevinamac · Post by **kevinamac** » Mon Feb 12, 2007 7:45 am

We are upgrading the SQL Server where we have Vault installed from version 2000 to 2005. We are at the same time changing the name of the server so we know this is going to break our connection from Visual Studio 2005 to Vault. What is the right way to proceed with this upgrade so that everything ends up right?

lbauer · Post by **lbauer** » Mon Feb 12, 2007 10:13 am

Backup your Vault database (sgvault), then uninstall Vault, keeping the database on the SQL Server machine.

Then upgrade SQL Server. Reinstall Vault.

For your Visual Studio projects, do a fresh open from source control, since all the bindings will need to be reset with the new server name:

Backup or delete all the projects in your working directories. For web apps, open with File->Open->Website->Open from source control.
For non-web apps, use the File->Source Control->Open from Source Control command.