How To Install under Different Database Name?

[JasonMSC]

Good morning,

After an excellent evaluation we recently decided to purchase Vault to replace our existing VSS databases. However, we require that our vault database not be named sgvault (we're working with a SQL2K service provider who does not provide us the ability to arbitrarly name databases). Configuring the web service doesn't look like it will be a problem, but how do we get the install program to create the version control database with a name other than sgvault?

BTW: Vault 2.0.1, Windows 2003 Server, SQL Server 2K.

Thanks in advance,
Jason Hess
Software Engineer
Miller Software Consulting, Inc.

[jclausius]

jason:

the install and database scripts do not allow control over the name of the database. in most cases this is usually not a problem.

you don't provide enough information about your setup, but ( as a guess ) one possible solution would be to install the server / database, and then rename 'sgvault' to a different database name. once the database has been renamed, change the database / catalog name in web.config's connect string.

on a side note, with the current release (vault 2.0.x) please be aware that a change in database name will require you to find an alternative method for database backups outside the admin tool.

hth

[Rossana]

Good afternoon,

We have some restrictions to create the database in company's server (nobody here has the permission to create a new database). So we are asking our Help Desk to create it, but they will create it in blank with the the default name: 'sgvault'. The question is if we can install the vault application having this database in blank.

With kind regards,

Rossana

[jclausius]

I don't believe the installation will allow for that.

Is there anyway you could run the installation locally, detach / backup the database, and then have the help desk attach / restore the database on the target server?