Skip to content
← Oracle

How can we improve our Oracle solution?

'Allow pre-filtering of objects before running a schema comparison' has been merged into this idea

Oracle: Schema Compare

Categories

Allow partial compare of schemas based on naming convention

We manage ERP systems with larg schemas (150.000 - 200.000 objects) where only a small proportion - the custom objects - should be under source control / schema compared.

To enable a decent use of Schema Compare for these systems, we would need to be able to compare schemas partially based on naming convention. Multiple assignments per schema should be possible, e.g. we want to match all objects for schema ABC matching the naming convention EE% and FF%

40 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…)
Alex 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
  • Kevin Woolfe commented  ·   ·  Report

    I would go further and suggest that I would like to exclude specific objects from comparison in the settings for the project. In Data Compare, I can choose the tables to be included or excluded by clicking on the Table & Views tab. I would like to have a similar UI to tell Schema Compare to always ignore some objects.

    Filtering by naming convention would be a start, but an Objects tab in Schema Compare similar to the Tables & Views tab in Data Compare would be more useful.

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

    You can do something similar to this via the command line using the filter file from Source Control for Oracle (a very simple xml file).

    We would like to push this feature back into the UI of Schema Compare for Oracle but we think it still needs a little more work to be really what people want.

    For more information see http://documentation.red-gate.com/display/SCO3/Command+line+switches#Commandlineswitches-/filter:<filterfile.scpf>

  • brett_hensley@firstdatabank.com commented  ·   ·  Report

    We have a very similar situation with many people sharing a single environment with various projects against the same schema. This option would make it possible for us to script for CI vs manually picking each object in the UI as is required now.

  • Colin Rimmer commented  ·   ·  Report

    Allowing the user to compare a smaller number of objects would help general use of the tool.

  • AdminNeil Anderson (Admin, Redgate) commented  ·   ·  Report

    Hi Alex,

    So you mean you would like to define filters to include (or exclude) certain objects using some sort of regular expression syntax?

    Thanks,
    Neil