Ignore objects

• 
  WTF? where is the support?

  tdobe October 09, 2017 14:12

  - 0 +
• 
  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 D October 10, 2017 10:37

  - 0 +

Add comment

Please sign in to leave a comment.