Find Vault version using vault database

[kha]

I am having a database (sgvault) on one of the sql servers, we want to look into this database to retrieve data as needed. But i don't know what vault version this database used when it was created. I don't think the IIS is still available. So, i would like to know the vault version via this database so then I can install the correct web application to retrieve data from this database. Any recommendation?

Thanks!

[Beth]

If you run the following query against your Vault database, you should get the database version.

Code: Select all

select * from sgvault.dbo.tblschemaversions

Make sure you make a backup of your database before you install.

If you post the version it shows you, I can make a recommendation for what to install. For example, if the database shows 5.0.0, then I could recommend you download and install Vautl 5.0.3 instead of Vautl 5.0.0. If your database says 4.0.0, then I would recommend installing Vault 4.1.4.

[kha]

It is 3.1.1

[Beth]

You will want to install Vault 3.1.9. It can be downloaded from this page: http://www.sourcegear.com/vault/downloads2.html.

Any interest in upgrading? Vault 3.1.9 is not supported on Vista, Windows 7, nor Windows 2008 server. If you wish to discuss options for upgrading, then send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread.

[kha]

This old vault database is from the crashed server and it was not got transferred to the new vault 4.1.4 (in production) server. So, we got request to retrieve repositories from the old vault databases and import it to the current vault in production (keep the history as possible).

So, my plan is to install the web app of vault 3.1.9 as you said on a test machine, then point it to 3.1.1 database. Then upgrade it to 4.1.4 so then we can use the Import and Export tool (if needed). Therefore, it comes to my question, which was the earliest version of vault that Import and Export Tool support?
I tried Import and Export Tool of 4.1.4 (current version we are using) and point it to the 3.1.1, it doesn't work. I figured it is due to the mismatch versions.

If we can by pass the upgrade to retrieve the repositories from 3.1.1 database and import it to the 4.1.4 and also can keep all the histories, please advise, that would make my life simplier

[Beth]

The earliest Export/Import is Vault 3.5.x, but it would be best to have it all match. I'd recommend upgrading your old database to Vault 4.1.4, then use the Export/Import tool on it. You can just use the admin account to login to the old version and perform the Export/Import. We have an Upgrading Guide that may help you during the upgrade.

One thing to make note of before starting is that if you've ever used the Obliterate function on your old database, then the Export/Import is not likely to work on it.

[kha]

Here is what I did and i ran into problem after the installation 3.1.9

1) I restored the 3.1.1 db to different sql server, same sql2000.
2) I installed the web app 3.1.9 on a different machine, pointed it to the db on step 1. Used:
- Custom - web.config identity Impersonation (the vault server and db server are on the same domain)
- DOMAIN\USER when it asks to for "logon information". The domain user account i used is in the domain admin group. So it has access to every server on the domain.
3) The web app & client installation went through fine. No error.
4) I opened the client and try to connect the sgvault server right on the machine on step 2, i use localhost for Vault Server box.
5) I got this error

The Vault Server could not establish a connection to the database. Please check the server's log for detailed information. (FailDBConn)

I never got the installation done cleanly without problem for my first try

[Beth]

What path did you use for the SQL database? Is there more than one instance installed?

Can you log into the SQL Enterprise Manager with the user you used during the install?

[kha]

What path did you use for the SQL database? Is there more than one instance installed?

In connectionstring of web.config, it shows that the database server = <sql server name>
This sql server has only one instance

Can you log into the SQL Enterprise Manager with the user you used during the install?

I used the same domain/user (that i used during the installation) remote desktop to the SQL server, and access the sgvault db on Enterprise Manager, then try to create test table, worked successfully.

BTW, the vault is installed under Default Web Site in IIS
So, it shows
Default Web Site
L VaultService
L VaultShadowFolder

[Beth]

Did you use SQL authentication or Windows authentication when you connected to the SQL server during the install?

In your SQL Enterprise Manager, can you see the domain user listed in the SQL Security logins? If you go to the sgvault database and look under users, do you see the same user listed there as db_owner?

[kha]

I used window authentication

Yes, i already checked that domain/user is the dbo and listed under sgvault/security/logins as dbo

[kha]

I can browse the VaultService IIS, it takes me to the Vault Home Page with subtitle: <vault server name> Server Installation
Version 3.1.9.3798 Installed <date>

With all the instructions ... I clicked on the link provided on the page under Web Client and try to login with "admin" account, it failed with "invalid login".

[Beth]

I can't really tell quite yet what could be going on with your database connection. Maybe a closer look might help. Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread?