Migrating 20 millions rows from MySQL to MSSQL

• pam-452379

  Newbie

  Points: 3

  More actions

  August 14, 2007 at 4:47 am

  #121032

  Hi all,

  I have tried to migrate the data from MySQL database to MS SQL by using MySQL ODBC 3.51 Driver as a connector. The error occured when I loaded the table which has more that 10 millions rows, the error show as follows

  "[MySQL][ODBC 3.51 Driver][mysqld -4.0.21]MySQL ran out of memory (myodbc.dll)"

  Moreover, I have used another driver (not a freeware), it worked completely.

  I would like to know where exactly the error are from, the driver itself or sth...

   

  Thanks in advance for every reply.

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  August 14, 2007 at 6:44 am

  #726747

  you've answered the question yourself - as it worked with a different driver the issue must have been the way the mysql odbc driver worked.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/