Tried Database Workbench from Upscene? It's a pretty decent tool and has means to pump data from one form database to another, as well as pretty decent exports to sql scripts and other formats you could try using:
http://www.upscene.com/ Kind regards, Scott :) Sid Gudes wrote: > 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 > > > _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
