Script Generation/Deployment should be consistent...but is not.
When generating a script from SQL compare, the script should be consistent, in that if I click “Deployment Wizard” 20 times on a database that has not change, the Deployment Script should be exactly the same and the behavior of the “Deployment Wizard” should also remain the same. This is not happening. Some of the issues I am seeing are as follows. 1. If I re-click the Deployment Wizard button after closing the Deployment Wizard, sometimes I get a warning about a dependency, that didn’t exist the first time I ran the “Deployment Wizard”. If I exit the “Deployment Wizard” and click “Refresh”, this seems to fix this problem. 2. If after I save a script to a file and then re-run the deployment wizard again, the resulting script is not consistent with the previous scrip that was generated. Both of these issues I can reproduce over and over again.
Thanks for contacting support. I’m updating this to be in the SQL Compare forum and for anybody else wondering, this is now logged as a bug in our issue racking system, ref SC-6824.