a better way to transfer data?
| From: | blackwater dev | Date: | Tue, 11 Apr 2006 14:05:22 +0000 |
| Subject: | a better way to transfer data? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-233762@lists.php.net to get a copy of this message | ||
Hello all,
I am currently running freetds on a linux box that needs to move data from a
remote mssql db to the local mysql db. I wanted to use bcp but freetds
couldn't as the data I am moving contains a blob field. I am currently
using php to select all the rows from the mssql db, and then looping through
the results and putting them into the local mysql db but this is horribly
slow and there has to be a better way.
How can I do this more efficiently?
Thanks!