bemara57
asked on
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.
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?
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.
I do wish you good luck finding the right solution.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.mysql.com/products/tools/migration-toolkit/