Ignore Roles

Forum for users of SQL Compare schema synchronization utility

Postby james.billings » Fri Jul 12, 2013 1:38 pm

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.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Postby johnfnz » Fri Jul 12, 2013 1:45 pm

That doesn't help because:

Code: Select all
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: Select all
Error: The selected objects are identical or no objects have been selected in the comparison.


I'll try the filer.
Posts: 11
Joined: Thu Jun 27, 2013 5:03 pm


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 4 guests