How to Ignore Affected Objects

davidnguydavidnguy Posts: 2
edited March 4, 2016 6:39AM in Schema Compare for Oracle
I'd like to automate the schema compare by running the command line as documented.
sco /project:"C:Schema Compare for OracleProjectsWidgetDatabases.ocp" /scriptfile:"C:Deployment ScriptsScript.sql"

If I want to ensure the generated deployment script will always ignore all the "Affected Objects", then what configuration or settings in the ocp file, do I need to change? I see that every time I open the OCP file using schema compare, the setting is not persisted.
4jmhe0.png

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi

    Thank you for your forum post.

    Would you please try adding the the '/excludedependencies' switch to your command line syntax, as follows:
    sco /project:"C:Schema Compare for OracleProjectsWidgetDatabases.ocp" /scriptfile:"C:Deployment ScriptsScript.sql" /excludedependencies
    

    This switch excludes dependent (referenced) objects from deployment.

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