How to transfer Vault 3.0.7 database to Vault 4.1.1?

tyip · Post by **tyip** » Mon Apr 21, 2008 1:57 am

I am attempting to transfer a Vault 3.0.7 database to a new Vault 4.1.1 installation on a totally different machine. How do I do this?

I've backed up (via SQL Server 2005) the old sgvault database to a .sgvbak file. On the new system, I attempt to restore the sgvault database from the .sgvbak file but I get the error:

"The backup set holds a backup of a database other than the existing 'sgvault' database."

I noticed that Vault 4.1.1 has a database called "sgmaster". What is this database? I do not have one on the Vault 3.0.7 installation.

lbauer · Post by **lbauer** » Mon Apr 21, 2008 7:13 am

Assuming the 4.1.1 is just an empty database from the new installation, we'd recommend the following steps:

1. Backup up your 3.0.7 database.

2. Uninstall 4.1.1, deleting the database when prompted.

3. Restore the 3.0.7 sgvault database to the new SQL Server location.

4. Since you are several versions out of data, you will need to upgrade in stages. Install Vault 3.1.9. This will upgrade the database.

You can get older installers here:
http://www.sourcegear.com/vault/downloads2.html

5. After the database is upgraded to 3.1.9, install Vault 4.1.1. This will also upgrade the database and add the sgmaster database, which is a new feature in Vault 4.x. It holds the user information.