Use "Add object existence checks" from commandline

[stephenk]

How do I use the "Add object existence checks" and "Use DROP and CREATE instead of ALTER" options from the command line

[Brian Donahue]

All of the options for the SQL Compare command line are noted here:
http://www.red-gate.com/supportcenter/Content/SQL_Compare/help/10.0/SC_CL_Command_Line_Options
It looks as if the documentation is out of date, though. I will get that looked into.

You would use /options:ObjectExistenceChecks,DropAndCreateInsteadOfAlter to accomplish what you want to do. For a shorter command-line, you could use the aliases for these options: oec and dacia respectively.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[stephenk]

Thanks.

The new options switches are also missing from SQLCompare.exe /? and SQLCompare.exe /verbose /? commandline help.

[Brian Donahue]

Odd, because I found thouse options the way I described... at least in version 10.1.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[stephenk]

I tried the switches oec and dacia but I get the following error:

SQL Compare Command Line V10.0.0.143
============================
Copyright © Red Gate Software Ltd 1999-2011

Error: Invalid value for switch /options: oec. Please use SQLCompare.exe /? or SQLCompare.exe /verbose /? for more information.

I also tried the full switch names, ObjectExistenceChecks and DropAndCreateInsteadOfAlter, but got the same error.

note the version downloaded from web is 10.0.0.143, not 10.1

[David Atkinson]

If you use Check for Updates in the tool (Help menu), it will download v10.1. This version will appear on the main download soon.

Apologies for this.

David Atkinson
Red Gate