Fundamental differences between Mysql and SQL server

Source: Internet
Author: User

1. The fundamental difference is that they follow the basic principle that the two follow is the main difference between them: Open vs conservative. SQL Server's narrow, conservative storage engine is very different from MySQL server's scalable and open storage engine. Although you can use the Sybase engine of the SQL Server, MySQL can provide more options, such as MyISAM, Heap, InnoDB, and Berkeley DB. MySQL does not fully support unfamiliar keywords, so it requires less related databases than the SQL server. MySQL also lacks some storage program functions. For example, the MyISAM engine supports the exchange function.

2. Performance: Advanced MySQL provides excellent performance simply because it contains a default desktop format, MyISAM. The MyISAM database is very compatible with the disk without occupying too much CPU and memory. MySQL can run on Windows without conflict. It is better to run on UNIX or UNIX-like systems. You can also use a 64-bit processor to obtain additional performance. Because MySQL uses 64-bit integers in many internal departments. Yahoo! Commercial websites use MySQL as the background database. When talking about the performance of the software, the stability of the SQL Server is much better than its competitors. However, these features have to be paid. For example, additional complex operations, disk storage, and memory loss must be added. If your hardware and software do not fully support the SQL Server, I suggest you select another database such as DBMS, because this will produce better results.

3. Release cost: MySQL is not all free, but it is very cheap to mention the release cost. The two products adopt two absolutely different decisions. For SQL servers, the most common way to get a free development fee is to buy Microsoft Office or Visual Studio. However, if you want to develop commercial products, you must purchase SQL Server Standard Edition. Schools or non-profit enterprises may not consider this additional fee.

4. Security Features MySQL has a binary log used to change data. Because it is binary, this log can quickly copy data from the host to the client. Even if the server crashes, this binary log is still complete and the copied part is not damaged. On the SQL server, you can also record SQL-related queries, but this requires a high price.

5. Security both products have their own complete security mechanisms. As long as you follow these security mechanisms, the general program will not have any problems. Both use the default IP Ports, but sometimes, unfortunately, these IP addresses are also broken into by some hackers. Of course, you can also set these IP Ports by yourself.

6. Restoration: Advanced SQL Server restoration is also a feature of MySQL, which is mainly manifested in the MyISAM configuration. This method has inherent defects. If you accidentally damage the database, the results may lead to all data loss. However, the SQL Server is very stable. The SQL Server can monitor data exchange points at all times and save the database corruption process. How to use a trigger to create a join table in a MySQL database

7. Decide your choice based on your needs. If you want to let me know which database is better, I may disappoint you. In my opinion, any database that is helpful to your work is a good database. No database is absolutely outstanding, and no database is absolutely bad. What I want to tell you is that you should start from your own needs, that is, what kind of task should you complete? Instead of simply starting from the functions of the software. If you want to establish a. NET Server system that allows you to access data from multiple different platforms and manage databases, you can select an SQL Server. If you want to create a third-party site that can read data from some clients, MySQL will be the best choice.

8. SQL-Server 2000/2005 is a medium-sized database developed by Microsoft. It provides excellent visualization, powerful security functions, and powerful technical support from Microsoft, of course, it is expensive and suitable for medium-sized systems. MySQL is a small database developed by MySQL AB. It basically has all the functions required by the database, but its functions are not powerful as SQL-Server, and the Technical Support cannot keep up with, but the price is low, it can be used free of charge when its license agreement is met, and is suitable for small systems. The same language (SQL) is a structured query language.

9. mssql is the Microsoft SQL Server. mysql, which runs on windows and platforms, is an open-source database Server that runs on windows, unix, and linux platforms. Its Standard Edition is free of charge, open source.

Comparison: 1. MsSQL is large and MySQL is small.

2. MsSQL can only be used in Windows, and MySQL is multi-platform.

3. MsSQL requires money. MySQL is free of charge (it is charged for windows, but rarely ).

4. MySQL is designed for WEB databases and features fast response. Of course, MSSQL cannot match in this respect.

5. SQL Server is better than MySQL in terms of stability

6. SQLServer is supported by many vendors and supports many languages. various drivers are also easy to get. SQL and MySql belong to the same relational database management system and strive to unify functions. Therefore, they share the same basic functions. MsSql is a powerful and silly product of Microsoft, the graphical interface is very convenient to use, just like a dummies camera. However, it's too big to be practical. Although mysql does not have a built-in graphical user interface, a large number of commands need to be remembered during use. However, if you use the same open-source EMS SQL Manager 2005 Lite for MySQL and PHP Admin, You will never lose to mssql. In common, all users use the SQL language (Structured Query Language ). Learn the SQL language well.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.