How can we improve our Oracle tools?

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
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    AlexAlex shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Kevin WoolfeKevin Woolfe commented  ·   ·  Flag as inappropriate

        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.

      • Richard MitchellAdminRichard Mitchell (Project Manager, Redgate) commented  ·   ·  Flag as inappropriate

        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.combrett_hensley@firstdatabank.com commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base