Trouble upgrading from 2.0.0.9

mkbrxvrt · Post by **mkbrxvrt** » Tue Apr 29, 2008 10:02 am

I am receiving the message from below.

Looking for IIS Version
Configuring your new Vault Installation
Requesting the IIS Process User...Requesting Vault Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for an existing databases...Found.
Asking for database's fate...Keep existing.
Upgrading the existing source control database...
This may take a long time. Do NOT stop this process!
Checking the installed database version...OK
Ensuring that sgvaultuser has access to the database... Grant database access to sgvaultuser...OK
Upgrading SourceGear master database schema...OK
Upgrading SourceGear source control database schema...Cannot find either column "dbo" or the user-defined function or aggregate "dbo.ufnmd5", or the name is ambiguous.
Invalid length parameter passed to the SUBSTRING function.
Caution: Changing any part of an object name could break scripts and stored procedures.
Caution: Changing any part of an object name could break scripts and stored procedures.
Error during Vault upgrade script.
The statement has been terminated.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280

lbauer · Post by **lbauer** » Tue Apr 29, 2008 10:33 am

We'd suggest upgrading in stages, as you are on a fairly old version of Vault.

Before you start:

Review the release notes for Vault:

http://support.sourcegear.com/viewtopic.php?t=792.

Update your licenses. Only Vault 4.x licenses will work with Vault 4.x.

--Backup up your current Vault database. It's important to have a good backup.

--If you're moving the database,. restore the sgvault database to the new SQL Server location.

--Install Vault Server 2.0.6, then 3.0.7, then 3.1.9. The installer will upgrade the database. You should backup each successfull database upgrade.

You can get older installers here:
http://www.sourcegear.com/vault/downloads2.html

--After the database is upgraded to 3.1.9, install Vault 4.1.1. This will also upgrade the database and add the sgmaster database, which is a new feature in Vault 4.x. Sgmaster holds the user information.

Users must also update their clients to 4.1.1. Your client and server versions should always match.

lbauer · Post by **lbauer** » Wed Apr 30, 2008 2:27 pm

This user reported that the suggested upgrade path worked well.