Undo Static Data Changes (or workaround)

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Undo Static Data Changes (or workaround)

Postby rand » Fri Feb 24, 2012 10:31 pm

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!
rand
 
Posts: 3
Joined: Fri Feb 24, 2012 10:10 pm

Postby csmith » Mon Feb 27, 2012 7:43 pm

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
csmith
 
Posts: 117
Joined: Thu Jun 30, 2011 2:15 pm
Location: Cambridge


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest