Re: data move from mssql to mysql via php
| From: | blackwater dev | Date: | Fri, 07 Oct 2005 15:29:41 +0000 |
| Subject: | Re: data move from mssql to mysql via php | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-223734@lists.php.net to get a copy of this message | ||
Matt,
So would you use an odbc driver and call it directly on the shell? I
don't have much access on the server or is this something I can do
through php?
Thanks!
On 10/7/05, Matt Darby <matt@matt-darby.com> wrote:
> 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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>