What are the challenges you face when working across database platforms? Take the survey
Options

Data Compare for Oracle - sequence of generated SQL

pparmarpparmar Posts: 1 New member
edited May 22, 2024 6:50PM in Data Compare for Oracle
Does the Data Compare product for Oracle generate a deploy SQL script based on the order of the foreign keys?   E.g., TABLE1 and TABLE2.   TABLE2 has an entry with a foreign key back to TABLE1.  So TABLE2 should be deleted first.    Would Data Compare generate the script in that order?   I realize there is an option to disable constraints, but that is not what I'm looking for.
Tagged:

Answers

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

    During the comparison phase, Data Compare for Oracle does check upon the dependencies between tables it is comparing.  So when generating the deployment script, the script should be generated in dependency order meaning that any data to be deleted in the target database/schema, the data TABLE2 would be deleted first and then deleted from TABLE1.
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.