Use "Add object existence checks" from commandline
stephenk
Posts: 4
How do I use the "Add object existence checks" and "Use DROP and CREATE instead of ALTER" options from the command line
Comments
http://www.red-gate.com/supportcenter/C ... ne_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.
The new options switches are also missing from SQLCompare.exe /? and SQLCompare.exe /verbose /? commandline help.
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
Apologies for this.
David Atkinson
Red Gate
Product Manager
Redgate Software
It seems ObjectExistenceChecks is always on in SQL Compare 10.2 when generating deployment script with command line. I'm using these options:
/Project:Core_rollout.scp /Scriptfile:Scripts\Rollout_2_Auto_Gen_Schema.sql /Force /ScriptEncoding:ASCII /Options:None,DecryptPost2KEncryptedObjects,IgnoreDatabaseAndServerName,IgnoreFileGroups,IgnoreFillFactor,IgnoreIndexLockProperties,IgnoreNotForReplication,IgnorePermissions,IgnoreReplicationTriggers,IgnoreStatistics,IgnoreUserProperties,IgnoreUsers,IgnoreWhiteSpace,IgnoreWithElementOrder,IgnoreWithNocheck,IgnoreConstraintNames,DisableSOCForLiveDBs,IgnoreStatisticsNorecompute,NoTransactions
and it always inserts existance checks.
The reason why I am trying to disable check is that SQL Compare generates strange name for bindings in the existance check part:
...AND default_object_id = OBJECT_ID(N'[dbo].dbo.[D_FlagFalse]]]', 'D'))
which doesn't work
Any ideas how to get rid of any of those 2 issues?
Kind regards
Taras