Vault/Dragnet to Fortress upgrade problem

fredriks · Post by **fredriks** » Thu Sep 06, 2007 7:37 am

Hello!

I'm trying to upgrade from Vault+Dragnet to Fortress. The current databases have different collations:

sgvault: SQL_Latin1_General_CP1_CI_AS
sgdragnet: SQL_SwedishPhone_Pref_CP1_CI_AS

The installation is failing saying that both databases must have the same collation. I've tried to change the Collation of sgdragnet to SQL_Latin1_General_CP1_CI_AS (same as master database), but I can not (Sample error message: "The object 'chk_timeestimates_status' is dependent on database collation").

I've also tried dropping all the objects mentioned in the error message (mostly constraints), changing collation (on both database and column level), and then adding the constraints again. The installation then starts but failes later on with another error message: "Upgrading SourceGear work item tracking database schema...Cannot resolve collation conflict for equal to operation"

Thankful for all help!

Beth · Post by **Beth** » Thu Sep 06, 2007 7:44 am

When we ran across another person that couldn't seem to get their collation to change for them, it was a case of where AUTO_CLOSE set to ON in one of their databases.

Would you check the properties of each of your databases and whether AUTO_CLOSE set to ON in any or all of them.

http://msdn2.microsoft.com/en-us/library/ms186823.aspx

fredriks · Post by **fredriks** » Thu Sep 06, 2007 7:51 am

Thanks for the fast reply! Autoclose is set to Off on:
1. sgdragnet
2. sgvault
3. master
3. model
4. tempdb

The database is SQL 2000 by the way. Could this be fixed by using a SQL 2005 server instead?
/Fredrik

Beth · Post by **Beth** » Thu Sep 06, 2007 1:09 pm

A script is being tested right now for you and will be sent via email in response to the email you sent to support. It will be sent out soon.