I cannot seem to get this option to work from SQL Compare command line.

I am trying to generate a script that can be ran each time the build is executed by comparing the baseline to the latest state of source control and generating a change script. For this to work each object would need an if exists/drop and create- I am only interested in doing this for stored procedures, user defined functions, and views. It seems like this is the intent of DropAndCreateInsteadOfAlter. I also have ObjectExistenceChecks specified. However, the tool still scripts this as simple ALTER and CREATE's.

Is this supported? I also tried another more manual approach from the MSSQL Studio Source Control plugin setup tab, by altering the configuration file to include the exact same options, but also I did not see that reflected in migration scripts when going that route.

Here is the command I am using when executing SQL Compare from command line for the setup described:

The option DropAndCreateInsteadOfAlter will script drop/create statements in the script, but not for any changes covered by the migration script.

If you use a migration script, it is going to use that exact script to go between the revisions covered by the migration script, regardless of any options you set. A migration script is effectively overwriting any default behavior that would normally occur.

Do you know if this particular deployment is using a migration script? An easy way to tell would be by repeating the comparison in the SQL Compare UI.

The option will only affect the script for changes outside of the migration script.

I think I asked the question in a confusing way, especially by mentioning migration scripts which I didn't intend to use.

What I am attempting to do may or may not be supported: I'm trying to execute SQL compare from the command line to compare two revisions in source control (Red Gate / SVN), and I want the output to be any stored procedure, view, or function that has changed scripted out as IF EXISTS / DROP / CREATE so I can run it with every build. It looked like dacia flag would do this.