Database Export

Hello everyone,

Im new to dbase development. I need your suggestions.

I would like to ask anyone who can give me a suggestion on what method or direction I should take on my project.

Im using Visual Studio Visual basic.net

The project is to export data from dbase4 to a mysql database fields. This involves matching up the fields in the dbase4 database to the mysql database.

The dbase4 database is constantly being updated by users. The export should update the mysql database also.

The export can happen during the night when the employees are not working.

I thought of transforming the dbase4 dataset to an xml file to mysql. Im not sure if this is the best way.

Any suggestions are appreciated.

Thanks