Scenario
dBase database is now getting obsolete. As a result those users who have used dBase and trying to migrate to other technology found that it is not easy to migrate .In one of our project we had to migrate our tables from dBase database TO MYSQL database.
Solution
After googling a lot and testing with different approaches I was not able to fulfill the requirement. Then I came across a site. This site provides different tools. Using this online tool, I have successfully migrated my database.
Above figure is the image of the tool, which I used to migrate the database. As per this tool we need to provide required information, such as .dbf, .fpt and the output format And click convert it. This will generate a .sql file as our output format was set for SQL and allow us to download the file.
Now we have our tables in sql format and we can run the file to create the required table. In my case , I had to create the table in MySQL, so i did some modification like changing data types and it successfully created.