How can we help you today? How can we help you today?

How to Ignore Affected Objects

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
davidnguy
0

Comments

1 comment

Sort by
  • Eddie D
    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 D
    0

Add comment

Please sign in to leave a comment.