Skip to content
← Oracle

How can we improve our Oracle solution?

Oracle: Schema Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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.

39 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • OliverMang commented  ·   ·  Report

    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.

  • Anonymous commented  ·   ·  Report

    We need to exclude lists of specific objects by database/client to avoid impacting local differences

  • Mike commented  ·   ·  Report

    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  ·   ·  Report

    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:
    http://documentation.red-gate.com/display/SOCO3/Filtering+objects

    I understand the limitation. It would be nice to have. Thank you.

  • AdminRichard Mitchell (Admin, Redgate) commented  ·   ·  Report

    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 richard.mitchell@red-gate.com