Re: data move from mssql to mysql via php
| From: | Matt Darby | Date: | Fri, 07 Oct 2005 14:37:45 +0000 |
| Subject: | Re: data move from mssql to mysql via php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-223733@lists.php.net to get a copy of this message | ||
blackwater dev wrote:
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!You can easily do this; you could also cut out the middleman and use the ODBC driver to import/export directly. HTH Matt Darby