Feature request: more interactive filter editing
weswinkler
Posts: 54 New member
I am using SQL Compare 8.2.1.62 where one database has lots of "extra" objects. These objects (tables, sprocs, and functions) are all created dynamically at runtime, and I exclude them from the comparison using object name filters.
All the objects follow a nice naming convention that supports such filters. E.g., tables are named TableRootOne_xxxx, TableRootTwo_yyyy, etc., where xxxx and yyyy are system-generated numbers. I use a rule like:
Object name Contains "TableRootOne_" OR Object name Contains "TableRootTwo_"
It would be very useful to me if there were an "APPLY" option in the Edit Filter Rule dialog that would, of course, apply the current filter, refresh the object list in the main window, and allow me to continue editing the filter.
This would allow me to build up my final desired filter incrementally.
All the objects follow a nice naming convention that supports such filters. E.g., tables are named TableRootOne_xxxx, TableRootTwo_yyyy, etc., where xxxx and yyyy are system-generated numbers. I use a rule like:
Object name Contains "TableRootOne_" OR Object name Contains "TableRootTwo_"
It would be very useful to me if there were an "APPLY" option in the Edit Filter Rule dialog that would, of course, apply the current filter, refresh the object list in the main window, and allow me to continue editing the filter.
This would allow me to build up my final desired filter incrementally.
Comments
I had spent some time constructing a multi-clause filter on an object, and I wanted to edit it. But, by accident I clicked the red X instead of the green pencil. The existing filter clauses were lost, and I had to start over.
Could you add a confirmation step when deleting filter rules? Perhaps this could be invoked only if the filter rules were "dirty" or unsaved.
Thanks!
Redgate Software