Convert MySQL database to MSSQL and upgrade PHP Scripts

[bimalpoudel]

Hi folks,
I need to migrate to MSSQL from MySQL. The application is complete and working in MySQL.
I do not know the detailed differences in SQL, connection objects etc about MSQSL.
I have more than 100 unique pages full of MySQL queries that do some basic things like:
searching, paginations, add/edit/delete of the records.

What factors should I consider while taking this change?
I would prefer to choose a quicker way to move the database, and upgrade the corresponding PHP Scripts.

Thanks.

[r937]

What factors should I consider while taking this change?

time

this is going to take a long time, and you need to allow for it

you will have to test every single query, and rewrite many of them