MS-sql to Mysql Migration Losing Data
Posted by: rev dave
Date: October 17, 2009 02:10PM

I am using MySQL Migration Toolkit 1.1 to migrate from MS-sql to Mysql. Currently the schema tables and fields transfer OK and many of the tables data transfer OK also, but there are some tables where much data didn't make it over. Either no records in 1 table, or only a few hundred made in another when there were 4000 in the source.

My guess is that there might be 'disallowed troublesome characters' in the various source fields like : single and or double quotes or returns or tabs or something like that ...

Q: Could these 'troublesome characters' be part of the problem? Could this be something else? How can I get the data transferred over easily?

Options: ReplyQuote

Written By
MS-sql to Mysql Migration Losing Data
October 17, 2009 02:10PM

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.