Re: a better way to transfer data?
| From: | Richard Lynch | Date: | Tue, 11 Apr 2006 21:54:45 +0000 |
| Subject: | Re: a better way to transfer data? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-233798@lists.php.net to get a copy of this message | ||
On Tue, April 11, 2006 9:05 am, blackwater dev wrote:
> 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?
Try dumping to CSV or tab-delimited and use LOAD DATA INFILE
--
Like Music?
http://l-i-e.com/artists.htm