Red Gate forums :: View topic - Undo Static Data Changes (or workaround)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Undo Static Data Changes (or workaround)

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rand



Joined: 24 Feb 2012
Posts: 3

PostPosted: Fri Feb 24, 2012 10:31 pm    Post subject: Undo Static Data Changes (or workaround) Reply with quote

My company is evaluating SQL Source Control 3. Static data management is the primary motivation in exploring this software.

I realize you can't undo static data changes (yet???). But seems like there should be some way to manually workaround it. Can you please let me know the best way to work around this limitation and effectively undo my changes?

Thanks!
Back to top
View user's profile Send private message
csmith



Joined: 30 Jun 2011
Posts: 114
Location: Cambridge

PostPosted: Mon Feb 27, 2012 7:43 pm    Post subject: Reply with quote

Hi

You should be able to rollback static data using Red Gate's SQL Data Compare - if you have a license for this product. You will need to populate a scripts folder with the the schema and data changes you want to rollback to and then deploy that back to your development database. You could then commit the changes in SQL Source Control to effectively rollback the data.

SQL Data Compare v10.0 will be realeased in the next few weeks that will enable a new button on the SQL Source Control v3.0's History Dialog allowing you to rollback static data to a selected version.

Best regards
Chris
_________________
Chris Smith
Project Manager
Deployment Manager
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