0 Replies Latest reply on Apr 20, 2008 8:09 AM by DettCom

    MS-SQL to Mysql

    DettCom Level 1

      I am trying to get data from a MS-SQL table into a mysql table using a MS-sql stored procedure. I have a sproc that runs and returns about 40k rows and inserts them into a temp table. It's great because it does it in about 1.5 seconds. Now the problem is getting it into a mysql table on another server in about the same timeframe.

      I tried creating a local package and transferring via an ODBC connection, but it is terribly slow.

      Would anyone have any suggestions???