Export tables and FKs

[CTzen]

Version: 5.1.x

When you choose tables to export (Tools->Export Tables->SQL Inserts), PL/SQL Developer starts analyzing dependencies between them, so it can generate statements to disable foreign keys and triggers.

Unfortunately it will analyze only selected tables, ignoring other tables that may have foreign keys to ones I selected. Since I choose [ ] Delete records option, generated script will fail on the destination database trying to delete records from parent table.

Is it possible to extend table analysis so it will catch all tables that reference ones I selected?

Thanks,
Slava

 

[Marco Kalter]

Do you want it to:

A. Implicitly include all child tables in the selection.

or

B. Generate a delete statement for all child tables.

------------------
Marco Kalter
Allround Automations

 

[CTzen]

A - No
B - No

I don't want to include all child tables, because 1) not all of them have changed rows, 2) I cannot overwrite some of them in another database.

So what I really want to see is that FKs are disabled for all child tables, even if I didn't select them explicitly.

--
Thanks,
Slava

 

[Marco Kalter]

I see. I have added this to the list of enhancement requests.

------------------
Marco Kalter
Allround Automations