Migration of Foxpro For Dos DBF tables into oracle 9i database

Asked By hasnatdastgir 20 points N/A Posted 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.

• Status: Open
• Question Views: 1086
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: FoxPro

Answered By Parsh Auguston 0 points N/A #158570

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.

1. Make sure that you create a backup of the data to somewhere safe.
2. Analyze all the risks that you will suffer during the conversion.
3. Split the database into pieces.
4. Categorize the tables into different categories.
5. Start by converting the smallest table first so that to see if the conversion process is stable and can handles the stuff.
6. If a database has over 500k records, split it into 5 parts according and then convert.

About Parsh Auguston

Questions
2

Answers
152

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 07/28/2012
• Question Category: FoxPro