Unable to roll back static data changes to repo version

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

Unable to roll back static data changes to repo version

Postby dpfresh » Thu Sep 22, 2011 5:24 pm

Hi all.. using svn with sql server 2008R2 and sql source control

I have a table that is linked as static data with local changes.

I want to roll back to the repo version but when I choose "Other sql source control tasks > Undo Changes" it shows nothing to revert.

Yet when I go to commit at the database level it shows local changes which I can commit to the repo.... stumped... please help a brother out.


p.s., I found the About menu easter egg.... nice. Asteroids rocks!
Posts: 1
Joined: Thu Sep 22, 2011 5:15 pm

Postby james.billings » Thu Sep 22, 2011 7:38 pm


Unfortunately, you can't "undo" static data changes as yet. See http://www.red-gate.com/supportcenter/Content?c=SQL_Source_Control%5chelp%5c2.2%5cSSC_Undo.htm&p=SQL%20Source%20Control

So you'll need to find an alternative way of reverting to the earlier data records.
Posts: 1121
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests