Hi everybody,
My goal is to insert data into multiples tables. (from an instance to other one)
I selected some tables, click on 'Export Data', select some options to have INSERT script, unique file, etc.
I get a file with all INSERT sequences
but
it's not taken into account of precedence regarding PK/FK.
That is to say, an INSERT will add data to a table referencing other one without having inserted data into this latter.
Is it by design or I missed something ?
Or perhaps there is an other Tool ?
Thanks in advance for replying.
Regards.
JL.
Export Data - INSERT SQL script format (relationnal precedence not respected)
Re: Export Data - INSERT SQL script format (relationnal precedence not respected)
Could you please provide us the following information:
1. Example of the exported file.
2. *.det data export template with your specific export settings. It can be generated by clicking the 'Save Template' button being on the last page of the Data Export wizard before you start export.
3. CREATE definitions of the exported tables.
4. Specify the versions of dbForge, Oracle client (if applicable) and Oracle server.
5. Screenshots would be also of help.
You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.
1. Example of the exported file.
2. *.det data export template with your specific export settings. It can be generated by clicking the 'Save Template' button being on the last page of the Data Export wizard before you start export.
3. CREATE definitions of the exported tables.
4. Specify the versions of dbForge, Oracle client (if applicable) and Oracle server.
5. Screenshots would be also of help.
You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.