How to Ignore Affected Objects

davidnguy

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.

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