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:
"C:\\Program Files (x86)\\Red Gate\\SQL Compare 10 SQLCompare.exe" /sourcecontrol1 /revision1:Latest /scriptsfolderxml:"C:
\\docs_mects\\branches\\TSv3.60 Database\\Scripts\\compare.xml" /migrationfolderxml:"C:\\docs_mects\\branches\\TSv3.60\\Database\\Scripts \\migration.xml" /scripts2:"C:\\docs_mects\\branches\\TSv3.60\\Database\\SourceSeed" /options:DropAndCreateInsteadOfAlter,if,ifg,iw,ie,iq,nt,iu,iup,ip,nc,oec /scriptfile:"C:\\docs_mects\\branches\\TSv3.60\\Database
Thanks for looking.