Asked By
amscott
20 points
N/A
Posted on - 04/02/2012
Good evening everyone.
I would like to ask a little of your time to explain the difference between these two.
By just reading on the name, they just seem to be the same.
What is the difference between MySQL Server from MS SQL Server.
MS SQL Server vs MySQL Server
Yes by name they look like same but there is much difference in both of them.
As SQL that stands for structured Query Language, is basically a language, which is part of different computer programs and especially of the relational databases programs.
Alone SQL is nothing it requires many other programs like oracle etc. to run. On the other hand My SQL is one of the computer programs and can be downloaded for free as it is open source.
MySQL can be called as database management system.
Hopefully your query is resolved and it has become clear that things that look alike are not necessarily alike.
MS SQL Server vs MySQL Server
Hi, both Mysql and Sql server will give you a good job on supporting all major protocol for accessing their databases.But there are some complaints against MYSQL which is it does not completely follow the ANSI SQL standard.You should upgrade your MYSQL to SQL if your data is constantly growing but remember to change the settings so that it will be able to communicate with the new data store that you established.In order to know the big difference between MYSQL and SQL.MYSQL is for selecting data on which you can saved delete and use it again,it is also a good choice in terms of tracking clients on which you need to do for your business online, for example maintaining your database or list of orders, clients name and details.
Technically SQL support triggers while MYSQL does not,SQL server support user define function MYSQL does not, SQL server have cursor support,MYSQL does not,SQL support stored procedures, MYSQL does not, SQL server have full join capabilities,MYSQL does not, SQL has full support for import/export capabilities, MYSQL has only limited support,SQL servers offers full Transaction support while MYSQL has limited transaction support.
