MySQL Forums
Forum List  »  Microsoft SQL Server

Importing text data from SQLServer in Mysql
Posted by: gareth gale
Date: January 31, 2005 10:28AM


Has anyone got any ideas on how to import a table that I have in SQLServer 2000 into MySQL that contains a (SQLServer) "text" column ? Here's the (SQLServer) sample table structure :-

id - int
details - text

The target table in mySQL looks similar, i.e.

id - int
details - longblob

Can you use the mysqlimport utility for this ? If so, given that the text field contains single and double quotes, as well as carriage returns and line feeds, how do you specify it ?


Options: ReplyQuote

Written By
Importing text data from SQLServer in Mysql
January 31, 2005 10:28AM

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.