How can we help you today? How can we help you today?

SQL Changeset with SQL Compare 8.0

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.
thom.bolin
0

Comments

2 comments

Sort by
  • Chris Auckland
    Thanks for your post.

    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?
    Chris Auckland
    0
  • David Atkinson
    Thom,

    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
    David Atkinson
    0

Add comment

Please sign in to leave a comment.