Unable to roll back static data changes to repo version
dpfresh
Posts: 2
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!
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!
Comments
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.
Redgate Software