Source control integration issues

Forum for users of SQL Compare schema synchronization utility

Source control integration issues

Postby Aleksandar » Mon Dec 12, 2011 6:23 am

After playing around with SQL Source Control and SQL Compare I just want some confirmation on an issue.

While using Compare to rollback to a previous version, i noticed that this action is not commited to Version control. I cant find any trace of this in the history log even though it has actually rolled it back. Am i missing something here, or is this not a feature?

If it isnt a feature, how would i go about making a note of the rollback through SQL Source Control?

Posts: 7
Joined: Mon Dec 12, 2011 6:05 am

Postby james.billings » Wed Dec 14, 2011 6:13 pm

Thanks for your post - Compare can work against source control revisions via the SSMS Integration Pack, but I'm not quite sure what you meant in your message.

How did you perform the rollback? Do you mean you set the target of the comparison to a source control revision and it didn't change any of the files? Or something else?
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Postby David Atkinson » Wed Dec 14, 2011 6:16 pm


When you rolled back, presumably with SQL Compare, did you remember to commit the changes back to source control? If you didn't, you have only rolled back your development database, but not source control. A roll-back should have caused a lot of blue indicators to appear on your database in the Object Explorer.

David Atkinson
Red Gate
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Postby Aleksandar » Thu Dec 15, 2011 1:23 am

First off should probably note im using shared db dev model.

I used SQL compare to roll back to a prevision version (from V80->v50). Source Control showed NO blue dots anywhere so i thought it had done nothing and closed/reopened SSMS. I wasnt prompted to update(get latest) the objects nor that there were any changes (i had no SSC indicator on bottom left of the DB icon at all).
I checked from a different account and SSC was v80 but had all of the objects were from v50, ie, it had been rolled back.

It seems to have overwritten v80 with the contents of v50 in Source Control.

From what your saying i should need to commit the rollback and that makes a hell of a lot more sense. Maybe this was just a bug/glitch.
Posts: 7
Joined: Mon Dec 12, 2011 6:05 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests