Exclude objects beginning with letter
Pete1
Posts: 5
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.
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
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?
Redgate Software
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
Product Manager
Redgate Software