MSSQL vs. MySQL

Reading time: 1 – 2 minutes

In the past month or so I have realized the pain of different Database Management Systems. Most of my projects have dealt with MySQL. An open source product that comes standard with most linux hosting packages, but in a current project I was required to switch gears and use MSSQL with PHP instead of MySQL.

Most of the things you do are very similar either way, but there a little things that absolutely drive you crazy.

First of all, the terminology is different( Key, Identity, Seed). Plus the majority of the data types are different and take some adjusting.

Other than the above things a lot is similar – such as mssql_query(), mssql_fetch_array(), etc…

To all of you who think one DBMS is the magic bullet, you should rethink your theory. As a good web developer you will need adapt to whatever the company is currently using, or whatever their hosting happens to support.

Share and Enjoy: