my sql is an open source database and can be used on any platform like windows,linux or mac. It is much easier to use. ms sql is a windows based database which can be used only on windows and is quite tuff to learn.
My SQL is open source database while MS SQL Server is micrsoft product. MY sql has limited facilites while sql server is very advance and having many other features like ETL , Reportic and Anlytics.
Technical - As of versions 4.x MySQL does not support views, triggers, stored procedures, user defined functions, XML, while all these are supported by MS-SQL Non Technical - MS SQL is an expensive (*relatively*) proprietary RDBMS developed & owned by Microsoft Corporation while MySql is an open source RDBMS developed & maintained by MySQL AB of Sweden with free as well as paid enterprise versions available. Source: geekpoint.net
hi, Mainly the applications are supported by MYSQL whereas MSSQL mostly supports Windows based applications only. If someone is looking for SQL database for an application which is not a Windows based application like PHP, HTML or any other, then I would suggest MYSQL as it is better for this purpose. Thanks!
MySql is a type of data base which is compatible with linux, windows, etc where as MS Sql is compatible only with windows.
Apart from some obvious bias here which I'll ignore, MS SQL is available as a free version too as MS SQL Express. It has most of the functionality of the more expensive versions, has a free mananagment tool (Sql Server Management Studio) and is enterprise-class in its abilities. If you have a choice of what DB server to use because you aren't constrained by your operating system, then MS SQL 2008 Express is a superior product.
MySQL was bought by Sun Micro in 2008, and has been owned by Oracle since 2010, not that this makes much difference to the OP but AB have been out of the picture for a long time.
MS SQL was actually initially forked from Sybase, which is still used a bit in the high end financial scene. They share a very bascially the same stored procedure language called T-SQL or Transact SQL
the difference between my sql and mssql ,these used in programming language because mysql used any plate from when ever mssql used only window