asked on 2/28/2007

Trying to sync ODBC server with MySQL database.. Possible?

I have a 3rd party software that uses proprietary flat files as its database. Luckily tho, the software has an ODBC option where I can have MS Access to read it's data files. Is there a way to get a MySQL database synched with the software data via ODBC. I imagine that the MySQL would act as the ODBC client and connect to the software. I'm trying to get MySQL synchronized with the software so I can make the data available to other softwares. I would only need to sync a few tables, not all of them. But there are tens of thousands of records, so it's no small data. Has something like this been done? Any help would be appreciated.

Enterprise Software MySQL Server Microsoft Access

Last Comment

Lieven Embrechts

5/18/2007

akshah123

2/28/2007

Well, you can use a free software available from the company that brought us mysql. It's intuitively called mysql migration toolkit. Try the following page for download & more info ...

http://www.mysql.com/products/tools/migration-toolkit/

bemara57

3/1/2007

ASKER

Hmmm, that's an interesting tool, but this seems like a one time task. I am looking for something that listens to both database and automatically keeps them in sync at all times, or even a few minutes delay. It would have to be a pretty efficient operation. Not sure if something like this exists?

akshah123

3/1/2007

Oh, my sincere apologies. I should have read your problem statement more clearly. I didn't realize you need a solution that would sync data. Unfortunately, I don't know of any tools that would do this for you.

I do wish you good luck finding the right solution.

ASKER CERTIFIED SOLUTION