Exclude objects beginning with letter

Pete1

When comparing two databases we want to exclude objects beginning with a certain letter.
For example, a database will have table names commencing with the letter "u" meaning user. This user table will be at one client's site but not at another. Similarly for views and procedures. We also have triggers on a table commencing with the letter "u" meaning a user trigger.
I can manually, for example remove tables that commence with "u" by unselecting that item, so they will not be selected. The same for procs.
Is there a way to do this on the 'Project Configuration', options tab?

Note - I only today downloaded the trial of SQLCompare. So far it looks very intuitive.

Michelle T

Not in the current version - the easiest way to do this currently is to do the comparison, then type 'u' in the 'Find' box and deselect all of the tables beginning with u that come up.

The next version will be able to filter by this kind of thing and save rules like this with your project (from the Filter sidebar which currently can only filter out whole object types). However, we treat a table and all its triggers as a seperate object, so you still won't be able to filter out individual triggers.

Does this answer your questions?

David Atkinson

Hi Pete,

We've just released a beta of SQL Compare 8.0 which has the functionality you are asking for.

http://www.red-gate.com/MessageBoard/vi ... php?t=8303

We'd very much appreciate it if you could try this out and let us know if it meets your requirements.

Kind regards,

David Atkinson
Product Manager
Red Gate Software