MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Data overflow error with MySQLODBC
Posted by: Tobias Brandt
Date: August 30, 2005 03:23AM

See bugreport #6452 for a workaround.
http://bugs.mysql.com/bug.php?id=6452

I personally found the workaround to be extremely slow and recommend using Access as a conduit if you can. Just create a new blank access database and set up a linked table to the MS SQL table you want to migrate to MySQL. Then right click on the linked table and choose "Export...", select "ODBC source" and then select the mysql datasource you want to use. THen just name your destination table and bob's your uncle.

In fact I started a DTS migration of a 13.5 mb table 15 min ago and it is still running! In the meantime I set up a new mySql datasource, created the access database, set up the linked table, exported in to MySql and wrote this post and DTS is still running!

Good luck!

Options: ReplyQuote


Subject
Written By
Posted
February 09, 2005 03:46PM
February 22, 2005 02:21PM
Re: Data overflow error with MySQLODBC
August 30, 2005 03:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.