Unable to create snapshot when comparing against an SVN rev

andreas_agrenandreas_agren Posts: 14
edited July 8, 2011 8:17AM in SQL Compare Previous Versions

I'm evaluating Source Control and SQL Compare for the company I'm working for.

Here's what I did:
1. Merge several revisions from the dev-branch into one new revision in the test-branch.
2. In SQL Server Management Studio I then right-clicked the database and chose Schema Compare/Deploy, and as source I picked Source Control and the new revision I just merged into in the test-branch.
3. As target I chose Database and then I clicked Compare/Deploy with SQL Compare.
4. In SQL Compare I didn't want to work directly against the db so as target I chose Snapshot and Create Snapshot....

Now, in the dialog that pops up no alternatives are available when Database is set as Data source type. See below image. Why is this?

I managed to work around this by starting a separate instance of SQL Compare and creating a snapshot there, then I repeated step 2-4 above and chose said snapshot in the dropdown box. Still, it seems weird that I have to do this extra step. Could this be a bug?



  • James BJames B Posts: 1,124 Silver 4
    Thanks for your post - I'm not 100% sure it's a bug but the behaviouor is certainly a bit confusing. When working with database revisions from source control, everything is triggered from the deploy screens in SSMS - this does disable the odd thing in Compare then. I'll log a job with the developers to take a look and make sure nothing too strange is going on here.

    Good that you found the workaround in any case!
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.