I am attempting to create a deployment script via CMD for SQL Compare. I have been unsuccessful at finding an answer though.
The end goal is to not sync the DB's via the command, but rather generate the deployment script itself like you can in the UI. CMD errors and says that /MakeScripts can not be used with the command /db2 though.
Is there another option I am overlooking?
This is what I was trying.
sqlcompare /db1:Shell_DB /db2:TargetDB /EXCLUDE:Certificate /EXCLUDE:Assembly /MakeScripts:"C:\SQLFileMerge"
The end goal is to not sync the DB's via the command, but rather generate the deployment script itself like you can in the UI. CMD errors and says that /MakeScripts can not be used with the command /db2 though.
Is there another option I am overlooking?
This is what I was trying.
sqlcompare /db1:Shell_DB /db2:TargetDB /EXCLUDE:Certificate /EXCLUDE:Assembly /MakeScripts:"C:\SQLFileMerge"