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?
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?
TechNet Community Support
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
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?