N/APosted on - 05/30/2012
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.