Data Compare for Oracle - sequence of generated SQL
pparmar
Posts: 1 New member
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
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.
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com