The question is that the organization maintaining data of employees in a Foxpro for Dos DBF tables. As the Foxpro for Dos is obsolete and do not fulfill the requirements of future, so the organization desire to convert/migrate the Foxpro for Dos DBF data of employees into oracle 8i or 9i database.
Have any body to resolve this problem. The detailed instructions are required to migrate/convert the data of employees safely, accurately.
Migration of Foxpro For Dos DBF tables into oracle 9i database
This is a very lengthy task and you need an expert for doing this. I have worked in oracle a lot and I have come across other conversions from other software’s but not from the FoxPro itself. Here is the list of things that we do first before proceeding.
-
Make sure that you create a backup of the data to somewhere safe.
-
Analyze all the risks that you will suffer during the conversion.
-
Split the database into pieces.
-
Categorize the tables into different categories.
-
Start by converting the smallest table first so that to see if the conversion process is stable and can handles the stuff.
-
If a database has over 500k records, split it into 5 parts according and then convert.
