Posted by blackwater dev on 10/07/05 18:29

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
>
>

• Next in forum: php array performance
• Prev in forum: Re: [PHP] data move from mssql to mysql via php
• Thread view: Re: [PHP] data move from mssql to mysql via php

[Reply to this message]