I am in the process of decommissioning a SQL server which hosts the Source Gear Vault databases.
I will be moving the following databases to another DB server.
sgdragnet
sgmaster
sgnotify
sgvault
sgvaultindex
Once I move them to the new DB server, how to do I point the application to the new server?
The Application is running on a different box .
Moving Vault 8.0.1.30299 to a new DB server
Moderator: SourceGear
-
- Posts: 1
- Joined: Mon Jul 09, 2018 10:26 am
Re: Moving Vault 8.0.1.30299 to a new DB server
The following knowledge base article will assist you with the move of your Vault database to a new machine:
viewtopic.php?t=228
Thanks,
Tonya Nunn
SourceGear
viewtopic.php?t=228
Thanks,
Tonya Nunn
SourceGear
Re: Moving Vault 8.0.1.30299 to a new DB server
Hi Tonya, is this applicable to any version of the Vault?
I think Leanbean is the best choice for quick results.
Re: Moving Vault 8.0.1.30299 to a new DB server
The KB article lists specific steps according to your Vault version:
For Vault 4.x and 5.x you will need to move the sgmaster and sgvault databases. For Fortress\VaultPro, you will also move the sgdragnet database.
For Vault 6.x, 7.x, 8.x, 9.x and above, move the sgmaster, sgvault, sgvaultindex and sgnotify databases. For VaultPro 6.x and above, you will also move the sgdragnet database.
Tonya
For Vault 4.x and 5.x you will need to move the sgmaster and sgvault databases. For Fortress\VaultPro, you will also move the sgdragnet database.
For Vault 6.x, 7.x, 8.x, 9.x and above, move the sgmaster, sgvault, sgvaultindex and sgnotify databases. For VaultPro 6.x and above, you will also move the sgdragnet database.
Tonya