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@xxxxxxxxxxxxxx> 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 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
