converting MSSQL to MySQL

[Luuk]

When trying to convert a MSSQL (2008 Express) database to MySQL (5.1)
My systems throws the following error:
Messages
Error 0xc020844b: Data Flow Task 5: An exception has occurred during
data insertion, the message returned from the provider is: Kan een
object van het type System.Int16 niet converteren naar het type
System.Char[].
(SQL Server Import and Export Wizard)

It claims it cannot convert a Int16 to a Char ?

then newly created table looks like this:
CREATE TABLE "dgmAttributeCategories" (
"categoryID" tinyint NOT NULL,
"categoryName" varchar(50),
"categoryDescription" varchar(200)
)


Anyone got an idea on how to solve this.... (without manually typing the
records into MySQL)

[Luuk]

Post by Luuk
When trying to convert a MSSQL (2008 Express) database to MySQL (5.1)
Messages
Error 0xc020844b: Data Flow Task 5: An exception has occurred during
data insertion, the message returned from the provider is: Kan een
object van het type System.Int16 niet converteren naar het type
System.Char[].
(SQL Server Import and Export Wizard)
It claims it cannot convert a Int16 to a Char ?
CREATE TABLE "dgmAttributeCategories" (
"categoryID" tinyint NOT NULL,
"categoryName" varchar(50),
"categoryDescription" varchar(200)
)
Anyone got an idea on how to solve this.... (without manually typing the
records into MySQL)

In case someone want to know the software versions i'm using to achieve
this:
Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3082
Operating System 5.1.2600