Posted by Ray Allison on 12/16/05 17:06

Hi,

I'm trying to copy table data from an SqlServer 2000 database to MySql 4.0
with a DTS package. Most data types copy OK except for SqlServer 2000 data
types 'ntext' and 'text' where the fields contain about 1000 characters.
MySql column types 'text', mediumtext or longtext are interpreted by DTS as
'long varchar', is this why the copy/Data Transformation fails? Does anyone
have any suggestions -- would it be better to use MySql 4.1 or 5.0?

Many thanks

Ray Allison

[Back to original message]