I'm trying to sync a legacy application (wich stores data in VisualFoxpro dbfs) to MySql or SqlServer 2005. This will allow us to see certain information online. I need this sync at least twice a day.
Does anyone know how to do this?
Thanks in advance.
I am not aware of any off-the-shelf software to handle this, but it would not be difficult using python, my dbf module, and one of the MySQL packages.
Once you have the script written, add it to the system scheduler to run as often as you need.
Very rough example:
This will hopefully get you started. Feel free to ask more questions.