Posted by Matt Darby on 10/07/05 17:37

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

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

[Reply to this message]