Post reply

DTS MySQL to SQL Server

  • March 30, 2006 at 12:00 pm

    #365731

    Hello all, I am in the process of migrating a MySQL database to SQL Server.  I am using DTS and is working great till I get to a rather large table.  I choose to copy tables and then select the table in question.  After a minute I get an error message stating "[MySQL][ODBC 3.51 Driver][mysqld-3.23.55.nt]MySQL Client ran out of memory"  At the time of the error the DTS process uses 1.7 GB of memory but that is far from all the memory available.

    Does anyone have any solutions???

  • April 3, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • May 13, 2006 at 10:31 am

    #637727

    Just like you did Table filtering, may be you can try ROW filtering for this ver table and upload chunk of data at a time (I believe its one time data transfer)


    paul

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply