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.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Unable to roll back static data changes to repo version

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

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

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.

-david

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

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

Hi,

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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests