Re: How to deal with table relationships where table is deleted and Inserted
This can get quite complex.
In an ideal world, you can:
1) DISABLE the constraints.
2) Delete/Import the data
3) ENABLE the constraints
However, when you hit step 3, due to RI, you might not be able to ENABLE the constraints.
Then the whole automated process will grind to a halt and some human will have to fix the
data before you can re-enable the constraints.
You probably should consider importing into a seperate set of tables, analyzing the new
data and Inserting/Updating the "real" data. That way any "exceptions" can be easily
flagged for the manual corrections before reprocessing.
Pool Players Know All The Angles