Options

includesourcetables option At dco For Oracle Data Compare

nikos74nikos74 Posts: 10 New member
edited November 12, 2020 2:27PM in Source Control for Oracle
We created a deployment comparing a branch with our objects with an empty branch. Having selected the above option Data for static tables were created. Between the release 02.01.01.00 and 02.01.01.01 some alters (add columns) were performed at not system tables and the data compare raised and error. Removing the new column and rerun the data compare no issue was raised. When this option was removed the data compare was performed successfully even when I added the alter of tables. 
My problem is that I do not want to have two different dco files. One for the execution from scratch and one between branches.
Regards 
Tagged:
· Share on Twitter

Answers

  • Options
    Eddie DEddie D Posts: 1,781 Rose Gold 5
    Hi, thank you for your forum post.

    If using the Command Line there is  (as you already discovered) the includesourcetables (alias o) via the /comparison switch.  Further reading here.

    For the GUI, there is the  'Take schema from the source' option. Via the GUI, Edit Project -> Select Options tab ->Comparison Behavior section.
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.