Red Gate forums :: View topic - How do I get command line to respect exclude arguments?
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

How do I get command line to respect exclude arguments?

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



Joined: 13 Mar 2012
Posts: 21

PostPosted: Tue Mar 13, 2012 8:29 pm    Post subject: How do I get command line to respect exclude arguments? Reply with quote

Based on the documentation for SQL Compare command line it seems I should be able to do this:

sqlcompare /Include:identical /exclude:assembly /Scripts1:'C:\TeamCity\buildAgent\work\c0ebf743024d92d6\trunk\Database\Databases\Intranet' /Server2:MYSERVER /Database2:Intranet

but the exclude switches seem to do nothing. The output clearly compares the assemblies anyway. I got

/exclude user

to work, but not role or assembly. Suggestions?
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Mar 15, 2012 9:57 pm    Post subject: Reply with quote

Thanks for your post. I suspect that the assembly is being pulled in because of a dependency. You'd need to, as far as I am aware, specify all the options you did want manually and not specify to include dependencies.

HTH!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
freecell1



Joined: 13 Mar 2012
Posts: 21

PostPosted: Fri Mar 16, 2012 5:50 pm    Post subject: Reply with quote

I figured it out. It looks like the /include:identical switch overrides /exclude switches, because when I took the include out it worked as expected.

This isn't the behavior I'd expect to see. I would think that

/include:identical /exclude:assembly /exclude:role

for example, would first exclude all roles and assemblies, and then produce a report of the remaining object types including identical ones. That's not how it works though ... I tried

/include:identical /exclude:role

to take assembly-related concerns out of the test, and it output a list that included roles ...
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