MSSQL and MySQL Comparison

Ms SQL refers to Microsoft's SQL Server Database Server , it is a database platform that provides a complete solution from the server to the end of the database, where the database server part is a Database management System for establishing, using, and maintaining databases.

Origin:SQL Server was not at first MicrosoftDevelopment of their own products, but at that time in order toIBMwhen competing, withSybaseThe earliest development of the partnership isSybase, and Microsoft alsoSybasehave cooperatedSQL Server 4.2version, Microsoft will alsoSQL Server 4.2ported toWindows NT(at the time3.1version), in relation toSybaseafter the termination of the partnership, self-developedSQL Server 6.0version, the futureSQL Serverdeveloped by Microsoft itself

Advantages: Ease of use, scalability for distributed organizations, data warehousing for decision support, integration with many other server software, good price/performance ratio, etc.
Cons: Can only run on Microsoft Windows platform, without the slightest openness to speak

MySQL is a relational database management system, by SwedenMySQLAB Company Development, currently belongs to OracleCompany. MysqlIt's the most popular.relational database management system, inWEBapplication MySQL is the best RDBMS (relational database Managementsystem: Relational Databases Management Systems ) One of the application software

Details:MySQL is an association Database management System, the associated database saves the data in a different table, rather than putting all the data in a large warehouse, which increases speed and improvesFlexiblesex. MySQL is used by SQL language is used to access Databasethe most commonly used standardized languages. MySQL The software uses a dual licensing policy, which is divided into community and commercial editions due to its small size, fast speed, low total cost of ownership, especially Open SourceThis feature, the general development of small and medium-sized web sites have chosen MySQL as the site Database. Thanks to the performance of its community edition, the pairingPHPand theApachecan form a good development environment

Pros: Lightweight, easy to deploy, open source, free (technical service is chargeable),MySQL almost has Most of Oracle's features to carry the vast majority of applications, MySQL You can tailor your database to different applications because MySQL the storage engine is plug-in.

Disadvantage: In the face of high concurrency, massive data, need rigorous database architecture design, otherwise performance will be problematic;

650) this.width=650; "Src=" http://img03.taobaocdn.com/imgextra/i3/652313122/tb2gvugxvxxxxboxpxxxxxxxxxx_!! 652313122.jpg "width=" 908 "height=" 272 "alt=" tb2gvugxvxxxxboxpxxxxxxxxxx_!! 652313122. "/>