SQL Server -> mySQL

[nullvalue]

I am trying to import a SQL Server 2000 database into a new mySQL database. I am using the DTS wizard in SQL Server to export the data. When I try to copy over a table with a ntext (BLOB) field, it bombs and give me the following error: "query-based insertion or updating of BLOB values is not supported".

Is this a limitation of mySQL itself or a limitation of myODBC? does mySQL really not support query-based insertion of BLOB values? if so, that'd really suck because the web site that I want to use mySQL for relies on BLOB fields for long paragraphs of text, etc.

Is there another import utility similair to DTS that would work?

thanks in advance.

--
nullvalue
BBSmates.com

 

[sleipnir214]

Have you tried using one of the open-source MySQL management products for Win32?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[autumn319]

no,i'm gonna use them .thanx from brittany,france