Hi,
I am trying to dump three tables from my database to file. I have used the tMSDump component which can backuptofile() and restorefromfile().
Table3 references table2, and table2 references table1.
Backuptofile() works fine.
The problem i am having is:
I cannot restorefromfile() in any order(table3 first/table1 first), because the TRUNCATE statement in the dump file always fails (which it should because it violates the FK rule).
So i cant really find a solution to dump these three tables into one file. I guess i need to
A: turn the FK constraint off before restoring or
B: Dump all tables at once (i.e. truncate all tables then restore in correct order - 1,2,3 so FK are preserved)
but i cant see an option for this in the TMSDump component. I am sure someone else wouldve had to do this before, so any help is appreciated.
Regards