MySQL Forums
Forum List  »  Microsoft SQL Server

MS SQL DTS - > MySQL
Posted by: Ben Ramsfield
Date: August 05, 2004 04:23PM

I have been trying to convert some information in my MS SQL server database to MySQL using DTS, so that the information can be dumped to MySQL on an automated schedule.

I am having a problem with a few fields. Specifically text fields which contain over 8000 characters. When the DTS package runs, I receive an error indicating that the query based insertion of Blob fields is not supported. I have tried CASTing the field, but because some of the fields contain more then 8000 characters I still receive the error.

I can use Access to "pass" the data from MS SQL server to MySQL. I can also use SQLyog to suck data from MS SQL and push it to MySQL.

Why won't DTS work? Is there any way to make this work from MS SQL / DTS?

Options: ReplyQuote


Subject
Written By
Posted
MS SQL DTS - > MySQL
August 05, 2004 04:23PM
January 22, 2005 04:29PM
February 03, 2005 03:21PM
February 09, 2005 01:31AM
February 07, 2005 05:05PM
February 11, 2005 07:34AM
February 14, 2005 08:16PM
February 16, 2005 06:19PM
July 25, 2005 11:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.