Export Data - INSERT SQL script format (relationnal precedence not respected)
Posted: 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.
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.