My plan is to backup the database from SQL Server 2000 and restore it on the 2005 server. Then I'll modify the web.config file to point to the new server.
Do you see any problems in doing this?
Thanks.
Migrating Vault 3.1 from SQL Server 2000 to 2005
Moderator: SourceGear
All the details for moving a Vault server can be found in this KB article: http://support.sourcegear.com/viewtopic.php?t=924
You are missing a step for recreating the recreating the users. The easiest is to perform a Vault server uninstall and reinstall. The SQL server queries for performing that manually can be found in the article I listed as well.
You are missing a step for recreating the recreating the users. The easiest is to perform a Vault server uninstall and reinstall. The SQL server queries for performing that manually can be found in the article I listed as well.
Thank you
This worked. Thanks.
Note, I didn't have to re-install Vault. I changed the db server name in the web.config file since I am using the same user to access the database.
Note, I didn't have to re-install Vault. I changed the db server name in the web.config file since I am using the same user to access the database.