We are in the process of revising our cdts, data stores and table structure for

We are in the process of revising our cdts, data stores and table structure for our applications. We are wanting to export the data from the current tables and import into our new structure. The challenge I am running into is that we are wanting to maintain our current identifiers (primary key values). Also, we have a couple of tables that have foreign key constraints that will not allow me to directly import into these tables.

Has anyone run into this situation before? How did you work around this situation? Will alter table disable keys work for these situations?

As usual any help or ideas are greatly appreciated....

OriginalPostID-106224

OriginalPostID-106224