Upgrading and Moving Vault

[jkbrower]

We are currently running Vault 4.1.2. We will be upgrading to version 5, but we also want to move the database to a new server. What is the correct way of doing this, when we're both moving and upgrading at the same time? Should we move ver. 4 to the new server, then upgrade, or the other way around, or something else?

[lbauer]

Are you moving just the database or both the database and the Vault server?

What version of SQL Server are you currently using and what version are you moving to?

[jkbrower]

The old server is being retired, so we're moving both database and Vault server, from SQL Server 2005 to 2008.

[lbauer]

You could upgrade in place, then move the databases to the new SQL Server, then install Vault 5.1.2 on the new machine.

But to save steps, I'd suggest this:

Backup your Vault 4.x databases, then restore the 4.x sgvault and sgmaster databases to the new SQL Server machine. Then install Vault 5.1.2 on the new web server machine, pointing it to the database location. The installer will upgrade the databases and create the proper permissions and logins in SQL server.

[jkbrower]

Thank you, Linda. That's exactly what I need.

[lbauer]

You're welcome.