none
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

    Wednesday, April 25, 2012 8:31 AM

Answers

All replies

  • 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

    • Marked as answer by MAW.FOERSTER Thursday, April 26, 2012 8:14 AM
    Thursday, April 26, 2012 6:03 AM
  • 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

    Thursday, April 26, 2012 8:17 AM