Can Vault 5.1 Be moved to SQL2008

[btd]

I have upgraded my Vault from 3.16 to 5.1 using SQL Server 2005.

Can the two Vault databases be installed on SQL2008 or SQL2008 R2?

If so, great.

Since my current installation is on SQL2005, what's all involved in getting my two Vault databases upgraded to SQL 2008?

Thanks

BTD

[lbauer]

Is the Vault Server staying on the same Web server machine? Or are you moving both Vault Server and the databases to new machines?

Vault 5.1 is supported on SQL Server 2008 and SQL Server 2008 R2.

If you are moving Vault to a new machine, you should backup your Vault databases, then restore copies of the databases to the new SQL Server location.

Then, install Vault, and point the installer to the new SQL Server location. The installer will upgrade the database schema, and create the necessary associations, accounts, and permissions.

If you're moving just the databases, then uninstall Vault, leaving the databases, then move the databases to the new SQL Server machine, and reinstall Vault, pointing the installer to the new database location.

Be sure to make good backups of your Vault databases (sgvault, sgmaster) before you do any of this.

[btd]

Do I need to upgrade to the latest version while I do this DB move from one server to another?
What's all new with the latest?

Thanks

BTD

[btd]

I was mistaken. Our current Vault database is on SQL Server 2000 SP2.

I am in need of "moving the Vault" database(s) to a different machine that has SQL Server 2008 R2 instance on it.

Question: Do the upgrade instructions change at all?

Thanks

BTD

[lbauer]

You should be able to restore a SQL Server 2000 database to SQL Server 2008, so the instructions remain the same.

According to this Microsoft article, the database being restored must be at least version 80 (SQL Server 2000) to restore to SQL Server 2008 R2. SQL Server 2000 or SQL Server 2005 databases that have a compatibility level less than 80 will be set to compatibility 80 when restored.

http://msdn.microsoft.com/en-us/library/ms186858.aspx

[btd]

Thanks for your information,
What about next version of Vault.
Should I upgrade AFTER I move the 5.1 databases or wait?

[lbauer]

What about next version of Vault.

Do you mean Vault 5.1.1?

After you move the 5.1 databases to SQL Server 2008 R2, you can install Vault 5.1.1. You don't have to install Vault 5.1 before upgrading to Vault 5.1.1.

Here are release notes on what's changed for 5.1.1.
http://sourcegear.com/vault/releases/5.1.1.html