Competition: What’s your favorite Redgate tool? Enter now.

Force migration script use with SQLCompare.exe

XaphanXaphan Posts: 18
edited May 17, 2013 5:25AM in SQL Compare Previous Versions
I'm using SQLCompare.exe to do automated deployments from my source control to my test environment. When a deployment occurs I noticed that migration scripts that I have stored in my source control only get used if SQLCompare.exe detects a loss of data when modifying a table. I would like the migration scripts to run regardless if data loss is detected or not. Is there a way I can force SQLCompare.exe to do this?


  • Migration scripts will always get run when a deployment includes the two revision number that the script is for. This is only not true when the option "ignore migration scripts for databases" is selected.

    If you are positive that the behaviour you are seeing is reproducible, please can you send reproduction steps to [email protected] and quote the support ticket number F0072982 in the subject line. This will allow any investigation to move forward, so please ensure that you include complete information.
Sign In or Register to comment.