MySQL Bugs: #10050: Data transfer from MS SQL 2000 to MYSQL 4.1

Bug #10050	Data transfer from MS SQL 2000 to MYSQL 4.1
Submitted:	21 Apr 2005 4:49	Modified:	22 Apr 2005 2:05
Reporter:	Murtaza Millwala	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	4.1	OS:	Microsoft Windows (Win XP/ SQL 2000)
Assigned to:		CPU Architecture:	Any

Description:
Data overflow error on transfer of data from sql server table to mysql server table.

Another error encountered when datatypes changed in mysql table from varchar to text or long text "The number of failing rows exceeds the maximum specified"

Numeric fields transfer easily.
main problem is with string type fields, especailly char/varchar

Have tried capacity control from sql to mysql using varchar in sql and longtext in mysql, but still doesnt work.

How to repeat:
have tried using DTS package as well as its import/export wizard, but the error is same in the end..

Suggested fix:
Could be ODBC driver (currently using 3.51.11)

could be differences in datatypes.

A more detailed understanding of this error can be based by creating same table (E.g. Employee (EmpId integer, Ename varchar() ) on both SQL and MYSQL.
insert some test data and then try to transfer the data to mysql employee table.

I get the same error with one table that has exactly the same number of columns and datatypes in both the SQL Server 2000 database and the MySQL 4 database.

Column 1 = int
Column 2 = varchar(70)