Undo

Comments

• Chris Auckland Posts: 769

  November 4, 2008 12:24PM

  Unfortunately not, the changes made are permanent.
  
  The only way to reverse the changes would be to restore from a backup.

  Chris

  0 · Share on Twitter
• Simon C Posts: 140

  November 4, 2008 1:01PM

  In the future, you can create a rollback script when you create the initial sync script by creating a new Work class with the runOnTwo argument to the BuildFromDifferences method negated. This will produce a sync script going the other way, if you wanted to undo the changes made by the first script.
  
  Simon C

  0 · Share on Twitter
• mtran Posts: 34

  November 5, 2008 10:19AM

  So to create the undo script:

              Work work = new Work();
              work.BuildFromDifferences(difference, Options.Default, false);
              using (ExecutionBlock block = work.ExecutionBlock)
              {
                  string sql = block.GetString();
                  difference.Database1.Dispose();
                  difference.Database2.Dispose();                
                  return sql;
              }
  

  
  I just need to set that flag to false?
  
  Thanks,
  Meng

  0 · Share on Twitter
• Simon C Posts: 140

  November 5, 2008 10:48AM

  correct - if runOnTwo is true, the sync script will go from DB1 -> DB2. If false, it will go from DB2 -> DB1. Changing runOnTwo does the same thing as flipping the synchronization direction in the SQL Compare UI.
  
  Simon C

  0 · Share on Twitter