Switching to SQL2K5 Compatibility after Vault Upgrade

c5thunder · Post by **c5thunder** » Mon Sep 24, 2007 11:43 am

We just upgraded our Vault/Dragnet installation to Fortress 4.0.4. This was done by detaching the Vault/Dragnet DBs from SQL2K SP4 and attaching to SQL2K5 SP2 server.

Everything seems to be working fine so far. Will I face any issues by changing the compatibility mode of sgvault and sgdragnet to 90 compatiblity?

Also, are there any post-upgrade scripts that should be run against the SQL DB to make sure there arent any errors?

Thanks

Beth · Post by **Beth** » Mon Sep 24, 2007 3:00 pm

I believe it should work in either compatibility mode. I usually have people do a back-up and restore and then SQL does the upgrade. Making the change to the compatibility mode property shouldn't hurt the functionality, but the articles on that seem to say to be very aware of the changes you force when you change compatibility modes.

Here's what was found on switching the SQL Server compatibility mode property:

http://mapamdug.blogspot.com/2006/03/sq ... cha-1.html

The above page has a link to here:

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