Red Gate forums :: View topic - Source control integration issues
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Source control integration issues

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Aleksandar



Joined: 12 Dec 2011
Posts: 7

PostPosted: Mon Dec 12, 2011 7:23 am    Post subject: Source control integration issues Reply with quote

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?

-aleks
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed Dec 14, 2011 7:13 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Wed Dec 14, 2011 7:16 pm    Post subject: Reply with quote

Aleks,

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
Back to top
View user's profile Send private message Send e-mail
Aleksandar



Joined: 12 Dec 2011
Posts: 7

PostPosted: Thu Dec 15, 2011 2:23 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group