If you want to be able to reverse a synchronization, or to return a database to a specific state, you can create a rollback script.

Before you run the Synchronization wizard:

1. In the main window, right click in the Direction Bar, and click Switch synchronization direction.
2. Use the Synchronization wizard to create and save a synchronization script.

For example, if you are migrating changes from WidgetStaging (the source) to WidgetProduction (the target), switching the synchronization direction makes WidgetProduction the source, and the synchronization script you create can be run on WidgetProduction in future to restore it to its current state.

You can also use SQL Data Compare to restore rows selectively from a backup.