Red Gate forums :: View topic - Use "Add object existence checks" from commandline
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Use "Add object existence checks" from commandline

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
stephenk



Joined: 24 Feb 2012
Posts: 3

PostPosted: Thu Mar 29, 2012 3:00 pm    Post subject: Use "Add object existence checks" from commandline Reply with quote

How do I use the "Add object existence checks" and "Use DROP and CREATE instead of ALTER" options from the command line
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Mon Apr 02, 2012 11:29 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
stephenk



Joined: 24 Feb 2012
Posts: 3

PostPosted: Mon Apr 02, 2012 12:12 pm    Post subject: Reply with quote

Thanks.

The new options switches are also missing from SQLCompare.exe /? and SQLCompare.exe /verbose /? commandline help.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Mon Apr 02, 2012 2:25 pm    Post subject: Reply with quote

Odd, because I found thouse options the way I described... at least in version 10.1.
Back to top
View user's profile Send private message
stephenk



Joined: 24 Feb 2012
Posts: 3

PostPosted: Tue Apr 03, 2012 9:57 am    Post subject: re: error when using oec and dacia options Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Tue Apr 03, 2012 10:23 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Taras B



Joined: 01 Jun 2013
Posts: 3

PostPosted: Sat Jun 01, 2013 3:13 pm    Post subject: Reply with quote

Hi

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
Back to top
View user's profile Send private message
Taras B



Joined: 01 Jun 2013
Posts: 3

PostPosted: Sat Jun 01, 2013 3:19 pm    Post subject: Reply with quote

Small addition to my previous post: seems ObjectExistenceChecks in my case comes from the .scp file and is not overriden by command line.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group