data move from mssql to mysql via php
| From: | blackwater dev | Date: | Fri, 07 Oct 2005 13:31:57 +0000 |
| Subject: | data move from mssql to mysql via php | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-223731@lists.php.net to get a copy of this message | ||
I have an app with a requirement to hit an external mssql db and move
the data to a local mysql database. What's the best way to do this?
I was thinking of querying the mssql db and writing the contents to a
flat file then using mysql load data from infile query to pump it in
but I am not sure if this is the best option so am looking for
suggestions....
Thanks!