>> 1. Identify the databases and datasets that are to be migrated
>> 2. Map fields of each dataset to fields in a relational database
>> 3. Establish the relation ships in the relational database
>> 4. Apply validations and correction routines to the data in
>> relational database
>> 5. populate oracle internal tables from the relational database
>> 6. run oracle interface to populate the oracle apps tables
>> 7. Repeat this process until the data migrated is clean
>>
>> If anybody has worked on a similar assignment or anybody who has an
>> idea about the possible holes in such a migration or any damn
>> knowledge of the same, pls. share
Again, If you know any Java, I would have to recommend JDBC. I did a
project that combines data from Sybase and Oracle that is a migration of
sorts because the data structures are so different. I'm adding ADBC to pull
in data from Image now. The performance is great and step 4 above is a lot
easier since you can control what maps to where and do any transformation or
lookups.
FWIW,
Mark W.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *