Re: change database from mysql to mssql
| From: | Torsten Roehr | Date: | Mon, 17 May 2004 07:34:27 +0000 |
| Subject: | Re: change database from mysql to mssql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-186393@lists.php.net to get a copy of this message | ||
"David" <dnj_2003@163.com> wrote in message
news:007201c43bba$3f9287e0$2201a8c0@dunjnotebook...
> Hi all
>
> I have been using mysql as the database for my PHP application.
> Now my manager ordered me to use Microsoft SQL Server as the database.
> I have been using the mysql interface to access the database, so I have
> to change my code.
> Which database interface should I use, ODBC, ADO, mssql or PEAR?
> Any brief suggestion or link to some good tutorial/paper would be very
> much appreciated.
>
Try PEAR::MDB or PEAR::MDB2 (as soon as it's stable) - this should also make
switching to another database easier in the future - back to MySQL maybe ;)
http://pear.php.net/package/MDB
http://pear.php.net/package/MDB2
Regards, Torsten