Move repository between servers

[Lucas]

We have the vault (4.0.3.15836) installed on a server with Windows 2000 Server and SQL Server 2000. We installed the vault on another server with Windows 2003 and SQL Server 2005.
How do move the repository to another server?
Make backup and restore does not work because it is different versions of SQL - 2000 and 2005

[lbauer]

You should be able to backup a database in SQL Server 2000 and restore it to SQL Server 2005:

http://msdn.microsoft.com/en-us/library ... L.90).aspx

If you are getting errors, here are some troubleshooting tips:

http://social.msdn.microsoft.com/Forums ... 2df961cee/

To move Vault, the steps would be:

Uninstall Vault on the Windows 2003/SQL Server 2005 machine.

Restore a copy of your Vault database from SQL Server 2000 to the new SQL Server 2005 machine.

Install Vault Server and point it to the new SQL Server machine.