Migration from MySQL to MS-SQL Server

From: Date: Fri, 09 Dec 2005 10:56:06 +0000
Subject: Migration from MySQL to MS-SQL Server
Groups: php.general 
Request: Send a blank email to php-general+get-227179@lists.php.net to get a copy of this message
Hi List, I want to re-implement a PHP-driven package named ATutor (http://atutor.ca) to work with MS-SQL Server. Currently, it works with MySQL. Unfortunately, authors of "ATutor" have not defined a class for database connectivity. In other words, they call each mysql functions directly in their code. It seems that I must change every line of code to make ATutor work with MS-SQL Server. 1) Is it suffice to replace every "mysql_FUNCTION" with "mssql__FUNCTION" in the code? I realized that most of MSSQL functions are very similar to MySQL functions, but their prefixes are different. (I should kindly thank the PHP Development Team for this) 2) I have not worked with MS-SQL Server before. Is there anything else which I should keep in mind? Thank you in advance, Behzad

« previous php.general (#227179) next »