We have little confusion to taking approach for Extracting data from source to target.
Our approach is:
- Drop the RI Constraints
- Truncate the Tables
- ReCreate the RI Constraints
- Extract data from source to target
Now confusion is during this process before or during recreating RI constraints if we loose DB connection or something outage happen then we loose to ability to Recreate
RI Constraints.What your thoughts and advice?