October 20, 2009 at 3:00 pm
I am using MySQL Migration Toolkit 1.1 to migrate from MS-SQL server 2005 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?
Q: Also is there a way to save the data from MS-SQL server 2005 to csv or tab delim. files?
May 9, 2010 at 12:55 am
I have a similar type of problem. I am a newbie to MS SQL. I need to migrate a database from ms sql 2005 to mysql. Can anybody help? Thanks in advance.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply