I am in a tough situation, and looking for advice on how to proceed. I have to import some data from one environment to another. 80% of the records have been modified, so the plan is to simply delete all the existing records, and import the new ones.
Unfortunately this is a base table. Several other tables have FK's defined, pointing at this table. In order to delete the data, I need to either drop the FK's and recreate them when finished the import, or disable the constraints and re-enable them.
No records have been deleted. A copy of prod was made, and developers have tweaked the data and added new records.
Which approach would you take?