Hi All, We're porting a database from MySQL to MS SQL 2000. I'm using mysqldump to dump the data out of MySQL, and Query Analyzer to execute the Insert statements in MS SQL.
Most of the data is portint OK, but I'm having a problem with one table that has some large blobs. There are two problems: 1) Query Analyzer seems to have a 64K limit on Insert statement size, but many of the blobs are over 64K. 2) mysqldump is escaping characters with a "\" character, but MS SQL doesn't seem to recognize those (e.g. mysqldump will generate 'don\'t port easily\r\n' which causes MS SQL to go bonkers) Any ideas on how to solve this? Other tools that would work? Or do I have to write a program to Select/Insert via ADO so I can set the blobs properly? Thanks for your help. Regards, Sid Gudes PIA Systems Corporation [EMAIL PROTECTED] _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
