March 21, 2009
What is the difference between MySQL and the Microsoft SQL? Which one is better?
Filed under Programming & Design by administrator
All about MySQL
Archives
Tags
Acquisition Apache Apache Php Backup Mysql Create Database Databases Knowledge Linux Microsoft Access Mysql Mysql And Php Mysql Data Mysql Database Mysql Databases Mysql Db Mysql Delphi Mysql Help Mysql Hosting Mysql Odbc Mysql Php Mysql Query Mysql Server Mysql Tutorial Mysql Windows Oracle php Php And Mysql Php Apache Php Database Php Form Phpmyadmin Php Mysql Php Tutorials Php Windows Running Servers String Text Tool Tutorial Mysql Ulbra Upload Upload Images Web Application Web Server YahooCategories
Copyright 2010
Comments on What is the difference between MySQL and the Microsoft SQL? Which one is better?
Here’s a very in-depth article comparing them:
Most of the differences are efforts of each developer to remain unique. So minor changes are made to ensure continued use.
Microsoft SQL has some functions not available in MySql, but the difference in capabilities is not really significant. I would say they are equally suitable for e-commerce. Security is a harder call, but my personal prejudice is for the open source software (MySql), as there is a developer community watching over it.
The biggest disadvantage of Microsoft SQL is that it has to be run on a Windows server. MySql can be run on virtually any platform. It is often used on Linux servers running Apache. Your software costs with MySql can be significantly less, though you may spend a bit more time setting it up.
The big difference is that Microsoft SQL is a proprietary of Microsoft, whereas MySQL is free (almost) and an Open Source database. You can download it from them, even the source!
Recently MySQL had just won from competition! (see from mysql website).
When you are searching for webhosting, you will see almost that their website are hosting for MySQL!