Am working with a propietary application that uses a dbisam database. We are looking to pipe scheduled updates from this source to a MySQL server (mostly likely on another box, but likely within the same datacenter). We have found and configured an ODBC driver that connects directly to the dbisam data.
Am looking for recommendations on a suggested tool/process/framework whereby we can either create a script, a service, or some compiled code that would trigger the connections and the updates on a schedule.
The originating side is definitely a Windows server box. The target side (and host of the MySQL) will most likely be Windows too, but it would be great if we had the option of it being a Linux server (not a requirement). Our desire is to use some PHP-based reporting tools against the MySQL data.
Would appreciate any feedback on how to do this.