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

• Next in forum: Re: Problem character set utf8 in Mysql 4.1.9-nt and ASP (v3).
• Prev in forum: Re: Updating record remotely from a script?
• Thread view: Copying from SqlServer 2000 with DTS

[Reply to this message]