Moving the Vault DB

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
btd
Posts: 324
Joined: Fri May 13, 2005 1:50 pm

Moving the Vault DB

Post by btd » Fri Jan 13, 2006 1:03 pm

Right now our Vault DB is on one server and the web site is on another server. Both are in the same domain.

I'd like to move the Vault database to a different database server on a different domain because our Op Team will back up the database for us automatically. I'd like to leave the website on the existing domain.

The domains are trusted.
My version of Vault is 3..5.2833


(a) Is this possible?
(b) If it is possible, what changes do my Vault clients have to make if any? See I'm thinkng no changes since Vault login asks for the web site on the log on screen and not the database.
(c) What changes on the web site do I need to make so it points to the new database server on a different domain? How does this handshaking happen.

Thanks

btd





web site
We'd like to move the Vault Database to a database server

jclausius
Posts: 3706
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Re: Moving the Vault DB

Post by jclausius » Sun Jan 15, 2006 8:15 pm

btd wrote:I'd like to move the Vault database to a different database server on a different domain because our Op Team will back up the database for us automatically. I'd like to leave the website on the existing domain.

The domains are trusted.
My version of Vault is 3..5.2833


(a) Is this possible?
Yes. The easiest thing to do is use SQL Server authentication for the connection. Also note, the SQL Server account will temporarily need Administrative priviledges.
btd wrote:(b) If it is possible, what changes do my Vault clients have to make if any?

(c) What changes on the web site do I need to make so it points to the new database server on a different domain? How does this handshaking happen.
The Vault server will need to be reconfigured to look at the new SQL Server. This is all controlled within Vault Server's web.config. Perhaps the safest way to proceed is to get a SQL Server administrative account and go over the KB article FAQ: Moving Vault (Server and Database) to a new machine

If the Vault server does not move, the clients will make no change, as they will still connect to the same machine.
Jeff Clausius
SourceGear

Post Reply