Undo Static Data Changes (or workaround)

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

Undo Static Data Changes (or workaround)

Postby rand » Fri Feb 24, 2012 9: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?

Posts: 3
Joined: Fri Feb 24, 2012 9:10 pm

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


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 Smith
Project Manager
SQL Lighthouse
Posts: 120
Joined: Thu Jun 30, 2011 1:15 pm
Location: Cambridge

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests