Schema Compare and rollback scripts
Posted: Mon 05 Oct 2015 20:50
We recently purchased Schema Compare, mainly to generate Deploy scripts between Test and Prod environments. We also need to generate equivalent Rollback scripts.
During our evaluation of the product, I had thought the generation of Rollback scripts was as easy as reversing the direction during the Synchronization step. The objects checked for inclusion were remembered.
Now that doesn't seem to work... do you really have to do a second Compare, remembering any objects that were flagged for inclusion during the generation of the Deploy script?
Tnx for tips.
During our evaluation of the product, I had thought the generation of Rollback scripts was as easy as reversing the direction during the Synchronization step. The objects checked for inclusion were remembered.
Now that doesn't seem to work... do you really have to do a second Compare, remembering any objects that were flagged for inclusion during the generation of the Deploy script?
Tnx for tips.