How to Ignore Affected Objects
davidnguy
Posts: 2
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.
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.
Comments
Thank you for your forum post.
Would you please try adding the the '/excludedependencies' switch to your command line syntax, as follows:
This switch excludes dependent (referenced) objects from deployment.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com