Conversion of Location Codes with Foreign Keys
From: Michael <michael.dietz_at_gmx.de>
Date: 28 Apr 2004 23:10:07 -0700
Message-ID: <e92fb27e.0404282210.1ae418d_at_posting.google.com>
I have to do a data migration for a client. The following conversion is required.
Date: 28 Apr 2004 23:10:07 -0700
Message-ID: <e92fb27e.0404282210.1ae418d_at_posting.google.com>
I have to do a data migration for a client. The following conversion is required.
Task:
- MOVEMENT table with 7,000,000 records, each has a location code
- Location code has changed; I have a mapping table with the old location code and the new code
Issues:
- The conversion should be done in the same table as I do not want to
move the 7,000,000 records from one table to another if not necessary
- The table has a foreign key to a LOCATION master; this means that I
might have to update LOCATION first; however, I cannot just convert
the codes in LOCATION as this would trigger foreign key violations in
Does anybody know what the best approach would be here?
Michael Received on Thu Apr 29 2004 - 08:10:07 CEST