allow exclude if object name begins with underscore (_)
In previous versions of sql compare you were able to use the underscore character as part of your filters (exclude if object name begins with _)
This no longer works and as underscores are fairly common when creating sample objects (at least in my company this makes it impossible for us to use.
This problem has been fixed in version 11.2 (currently only available via frequent updates). We have added new ‘Like’ and ‘Not like’ filter match operators which honour all SQL LIKE wildcards, and changed the previous ‘Begins with’, ‘Ends with’, and ‘Contains’ to stop treating them as wildcards.
You may need to edit existing filters to take advantage of the new behaviour.
-
Iain Elder commented
You can do this with filter rules in SQL Compare 10.
Set up a rul for all object types that says "Exclude if object name begins with _".
http://www.red-gate.com/SupportCenter/content/SQL_Compare/help/10.2/SC_Using_Filters