SQL Server 2000 to SQL Server 2005/2008?

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
spatialminds
Posts: 16
Joined: Tue Sep 09, 2008 8:56 pm

SQL Server 2000 to SQL Server 2005/2008?

Post by spatialminds » Tue Aug 10, 2010 1:24 pm

We are looking to upgrade our database from SQL Server 2000 to SQL Server 2005 or 2008. Is there anything unique we need to do for vault to work with the upgraded database? Our plan is to run backup of our existing database and then follow the MS upgrade guide. What steps do I need to do on the vault side?

Thanks,
Craig

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: SQL Server 2000 to SQL Server 2005/2008?

Post by Beth » Tue Aug 10, 2010 4:19 pm

What version of Vault are you running?

If you aren't running a very old version, then there isn't anything to worry about. Just make a backup of your sgvault and sgmaster databases before the upgrade. If your Vault version is prior to Vault 4.1.x, then the version of Vault versus the version of SQL you are going to needs to be looked at.
Beth Kieler
SourceGear Technical Support

Post Reply