Red Gate forums :: View topic - Ignore Roles
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

Ignore Roles

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Go to page Previous  1, 2
Author Message
james.billings



Joined: 16 Jun 2010
Posts: 1120
Location: My desk.

PostPosted: Fri Jul 12, 2013 2:38 pm    Post subject: Reply with quote

OK, I think the main issue here is that the include:identical is "winning" (all the Roles you see are identical ones, not ones where there's a difference).
I don't think there's any way to combine include/exclude like this and actually control what happens. It's recommended to use a filter rather than exclude now anyway (so create a filter excluding roles in the GUI and save it to a .scpf file, then reference this with the /filter switch).

Even doing this, include:identical "wins", however there's a new switch now which omits the need for that: /assertidentical.
Using that switch will stop the error occurring on identical DB's but also not include identical objects in the output.
Back to top
View user's profile Send private message
johnfnz



Joined: 27 Jun 2013
Posts: 11

PostPosted: Fri Jul 12, 2013 2:45 pm    Post subject: Reply with quote

That doesn't help because:

Code:

Error: The /assertidentical switch cannot be used in conjunction with the /synchronize switch. Please use SQLCompare.exe /? or
SQLCompare.exe /verbose /? for more information.


If I remove include:idential then I just get the
Code:

Error: The selected objects are identical or no objects have been selected in the comparison.


error.

I'll try the filer.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page Previous  1, 2
Page 2 of 2

 
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