MySQL into MSSQL DB Error > Converted datatypes

Question

Hy,

the Problem / Error Message is:

The given value of type Byte[] from the data source cannot be converted to type tinyint of the specified target column.

The source DB is a mysql with Colum Data Type: Bit(1) and the Source is a MSSQL DB with Colum Data Type tinyint

Has anybody an idea?

Thanks

Answer 1

Hi MAW.FOERSTER,

Could you please try to use SQL Server Migration Assistant for MySQL tool to do the migration? Is it possible to use bit data type in SQL Server as the target column?

---

Stephanie Lv

TechNet Community Support

Answer 2

Hy Stephanie,

many thanks .... I try the "create Report" in th SSMA Tool and create the target with binary(1). After the import I converted the column with an alter table ... it works !!!

Great answer ... thx