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.
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