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

Before you run the Deployment Wizard:

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

For example, if you are migrating changes from WidgetStaging (the source) to WidgetProduction (the target), switching the deployment direction makes WidgetProduction the source, and the deployment 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.