Need the filter capability that SQL Compare currently has
SQL Compare allows the user to use a customized filter to exclude specific objects, object types, or objects with a certain named pattern.
This would be extremely useful in the Oracle tool as well.
Ignore Rules were implemented in v5.2 for Schema Compare, Data Compare, and Source Control for Oracle. More details can be found at https://documentation.red-gate.com/ddfo/other-resources/list-of-released-features. We hope this meets your needs and looking forward to hearing your feedback.
Product Manager, Database DevOps
We'd find it useful to exclude objects by name pattern as well as full name, depending on the project. Something like a project-specific filter.scpf would be great.
We need to exclude lists of specific objects by database/client to avoid impacting local differences
This would be very useful to exclude objects that cause application errors in other tools, such as Oracle Schema Compare. The specific case that led me here is comparing on IN MEMORY objects in 12c Exadata in Schema Compare. I've developed a habit of not clicking on the row for these objects (when the comparison text is generated is when the error occurs), but ideally I could encounter this, add a filter, and move on w/o maintaining a list outside of the application.
AdminEddie (Admin, Redgate) commented
We're trying to create a project using filters to only include triggers and containing text 'EDD'. The project returns all triggers and doesn't seem to only be the ones with 'EDD' in the object name.
The Filter currently available in Source Control for Oracle is not that flexible. Also it is not immediately obvious that you can only filter objects based on their type, ie Triggers, Tables, View etc, Or by name. This help article confirms this:
I understand the limitation. It would be nice to have. Thank you.
Actually I'm currently working on that feature for Source Control for Oracle. Once it is complete I'll probably back-port the code in Schema Compare. It's not quite as flexible as the SQL Compare system but I think it's enough.
If you want to see the experimental build for Source Control for Oracle with filtering just let me know at email@example.com