SQL Changeset with SQL Compare 8.0
thom.bolin
Posts: 12
I am setting up SQL Changeset with our VSS environment. When I compare the live database to the scripts I get objects that do not exist in the scripts and objects that do not exist in the live database. These objects exist in both locations, however the object owner is not dbo. This is SQL2000 sp4. Am I doing something wrong that is making these not compare correctly. ie, application_dbo.tbl_lookup exist in the script folder and the databse but it shows up in both panes as only existing in one location.
Are others using SQL Changeset with VSS, if so any advice would be helpful.
Are others using SQL Changeset with VSS, if so any advice would be helpful.
Comments
I think I have managed to reproduce this. Can you make sure that the 'Comparison settings for script folders' is set to SQL Server 2000?
You can set this in the 'Data sources' tab of project configuration, or confirm that it's set to version 8 in the RedGateDatabaseInfo.xml file.
If it's set to 2005 or above, then the script parser is expecing a schema which causes the engine to get very confused.
Can you check this and see if it helps?
I'm curious to know what your plans are regarding the impending end of life for Visual Source Safe? Has your organisation got plans to move to different system?
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software