Sql-server – migration sql 2003 to 2008, Sql side and php side

PHPsql server

I have a system in php using MSSQL 2003. I need to change the database to MMSQL 2008.

I want to know if there's issue I should look at on

  • SQL Side (Query/SP/….)
  • PHP Side (Query, connection type, …)

Answer will be usefull even if it is a "dont worry, using standard connection will work" or "there's not so much depricated function between 2003 and 2008".
If you goth link to other posts answering some of those interrogation or how to see it by myself.

Best Answer

There is no MSSQL 2003, so you must mean MSSQL 2005, right? Are you trying to upgrade? Do you have a development environment you can test in? That's your best course of action. Other than that, I'm not sure what you're asking exactly.

But I've upgraded from 2005 to 2008 using a PHP environment before and nothing broke. There might be some deprecated features in 2008 but as far as I know they haven't been removed from the engine, just deprecated. Most everything should work. But again, try it out in a development environment.