SQL Change Automation 4

Rolling back ad-hoc using SQL Compare

SQL Compare can deploy a database associated with a SQL Change Automation project back to a previous state by checking out a previous version of that project from version control, although there are a number of caveats.

Run the following steps:

  1. Check out the version of the project to roll back to from version control
  2. Use SQL Compare to update your development database using the SQL Change Automation project
  3. Check out the latest of the project from version control
  4. Open the project in your IDE of choice
  5. Generate a migration script from the differences between your database script and project. This can be used as a revert script by deploying your project as normal

Didn't find what you were looking for?