MYSQL migration to MS sql 2005 using PHP
Posted on 2006-10-19
im currenly using Mysql as my database manager, however i'd now like to use MSSQL 2005,
my question is, what steps do i need to take to make the change (in terms of updating the PHP code)
are there any differences in the query and connection strings?
are the full text search strings also the same ?
$sql = "
MATCH (item,description) AGAINST ('$query') AS score
WHERE MATCH (item,description) AGAINST ('$query')
ORDER BY score DESC
does any of this need to be changed?