Performing and Performing once again; today, we need much quicker database access than we currently have: we have some Windows servers contacting with the sql database using Microsoft's SQLClient driver for accessing it.
The idea was to cache some frequently used data on the servers in the in memory databases. The problem was copying the tables' schema from the sql server to the mysql without doing in manually. So:
I wanted to recommend the Michael Kofler software . I used the gui versions and had only one problem : they both require the correct MySQL ODBC driver. I used the last version located at http://dev.mysql.com/downloads/connector/odbc/3.51.html#winx64 and nothing worked , because the MySql server version installed was not 64 bit (what a pitty ) therefore, reinstalling the Windows MSI Installer (x86) version solved the issue and the table had been copyed in notime
Thanks Micael
No comments:
Post a Comment