Skip to content
← SQL Compare

How can we improve SQL Compare?

SQL Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Add a Rollback Script Save option for both SQL Compare & Data Compare

In order to create a rollback script, we currently need to reverse the direction of deployment, save the rollback script, cancel the deployment, change the direction, then proceed with deployment in the correct direction. It would be great if the same screen on the Deployment Wizard would allow you to save BOTH a change script and a rollback script.

103 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Kevin shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ram Sola commented  ·   ·  Report

    Currently there is no functionality of creating rollback script when deployment script is generated using SQL compare. It will be really helpful if we can have rollback script as well when we are moving new changes to target we should be able to rollback them using script and not using backup or snapshot

  • kenzo commented  ·   ·  Report

    Rollbacks are a real world reality. Depends on the environment but anybody who deploys object changes to database will eventually need to do a rollback.

    Would be a great, repeat great, feature that would set sqlcompare apart from competitors.

  • Jeff Taylor commented  ·   ·  Report

    I have worked with many companies which require this. Most large 'old school' IT companies ALWAYS require a rollback in case of issues during deployments. If you need information about this feel free to contact me.

  • Andrew commented  ·   ·  Report

    This would be excellent. I pre-generate rollback scripts for all of my deployments, and it's unfortunate that the new compare with reversed direction doubles the overall generation time. Built-in support for this would hopefully use the same temporary files as the original compare, reducing the performance overhead.