Export Data - INSERT SQL script format (relationnal precedence not respected)

Export Data - INSERT SQL script format (relationnal precedence not respected)

Postby SQL4Fun » Thu 25 Sep 2014 13:59

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.
SQL4Fun
 
Posts: 3
Joined: Thu 25 Sep 2014 13:45

Re: Export Data - INSERT SQL script format (relationnal precedence not respected)

Postby alexa » Thu 25 Sep 2014 14:15

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.
alexa
Devart Team
 
Posts: 2171
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle