Ignore objects

How to ignore objects (by names) in a project?
Tagged:

Comments

  • tdobetdobe Posts: 5 Bronze 2
    edited October 9, 2017 2:22PM
    WTF? where is the support?
  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi Tdobe

    Sorry, not sure how we missed this one.

    Using the Schema Compare for Oracle GUI, you cannot filter by object name in a project.

    If this is a feature you would like to see added to a future version, please vote and comment on this UserVoice forum topic:
    https://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/6312992-need-the-filter-capability-that-sql-compare-curren

    If using the Schema Compare for Oracle command line, there are a couple of workarounds you may wish use, that allow the user to filter by object name.

    The first option is use the /exclude:<behavior> switch so you can exclude objects that are:

    Missing - To exclude any object only in the source that would generate a CREATE statement.

    Different - To exclude any object in the source and target that is not equal, do not generate ALTER statements for these objects .

    Additional - To exclude any object only in the target that would otherwise cause a DROP statement.

    The second option, which I believe maybe more useful to you if you also make use of Source Control for Oracle, is to use the /filter:<filterfile.scpf> switch. In Source Control for Oracle, you can filter object by object name. This filter is then saved as a separate file with a scpf file extension, filter.scpf. You can then take a copy of the filter file and use it with this switch to filter the required object name. For example:
    sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp" /deploy /filter:"C:\ScriptsFolder\filter.scpf" /excludedependencies
    

    Further information on the command line switches can be found in the link below to the help documentation:
    https://documentation.red-gate.com/display/SCO4/Command+line+switches

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.