Exclude objects beginning with letter

Pete1Pete1 Posts: 5
edited January 12, 2009 8:42AM in SQL Compare Previous Versions
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.

Comments

  • 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?
    Software Developer
    Redgate Software
  • 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
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.