Re: [PHP] data move from mssql to mysql via php

2005-10-07 Thread Richard Lynch
On Fri, October 7, 2005 8:31 am, 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

Re: [PHP] data move from mssql to mysql via php

2005-10-07 Thread Greg Donald
On 10/7/05, blackwater dev <[EMAIL PROTECTED]> wrote: > 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? Most of the time someone has already been there and done that: http://www.kofler.cc/mys

RE: [PHP] data move from mssql to mysql via php

2005-10-07 Thread Jay Blanchard
[snip] 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? [/snip] There is an odbc driver for MySQL http://dev.mysql.com/doc/mysql/en/odbc-connector.html -- PHP General Mailing List (http://www.ph

Re: [PHP] data move from mssql to mysql via php

2005-10-07 Thread blackwater dev
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 <[EMAIL PROTECTED]> wrote: > blackwater dev wrote: > > >I have an app with a requirement to hit an external m

Re: [PHP] data move from mssql to mysql via php

2005-10-07 Thread Matt Darby
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