Prev: cf trim
Next: Dynamic named arguments
From: DettCom on 20 Apr 2008 11:09
Hello,

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???


Thanks!!!

 | 
Pages: 1
Prev: cf trim
Next: Dynamic named arguments