Talking about the difference between MySQL and SQL Server

For program developers, the two most popular background databases currently used are mysql and sql server. The most basic similarity between the two is that the data is stored and belongs to the query system. You can use SQL to access the data for both databases because they all support ansi-sql. Also, both of these database systems support binary keywords and key indexes, which greatly accelerates query speed. At the same time, both provide various formats that support XML. Apart from the obvious differences in the price of software, what are the obvious differences between these two products? How do you choose between the two? Let's look at the major differences between the two products, including the issue fee, performance, and their security. The fundamental difference between   is that they follow the basic principles   the basic principles they follow are their main differences: Open vs Conservative. The narrow, conservative storage engine of SQL Server is different from the extensible, open storage engine absolutely of MySQL server. While you can use the Sybase engine of SQL Server, MySQL can provide more options such as myisam, heap, innodb, and berkeley db. MySQL does not fully support unfamiliar keywords, so it is less relevant than SQL Server database. At the same time, MySQL also lacks the functions of some stored programs, such as the MyISAM engine to support the Exchange function.   Issue fee: MySQL is not all free, but very cheap   when it comes to the cost of the release, both products adopt two absolutely different decisions. For SQL Server, the most common way to get a free development fee is to purchase Microsoft Office or visual studio fees. However, if you want to use the development of commercial products, you must also purchase sql server standard edition. Schools or non-profit enterprises may not consider this additional fee.   Performance: Advanced mysql  purely in terms of performance, MySQL is pretty good because it contains a default desktop format MyISAM. The myisam  database is very compatible with the disk without consuming too much CPU and memory. MySQL can run on windows without conflict, and it is better to run on UNIX or similar UNIX-like systems. You can also get some additional performance by using a 64-bit processor. Because MySQL often uses 64-bit integer processing in the interior. Yahoo! 's commercial website uses mysql  as a back-end database.   When mentioning softwareperformance, SQL Server stability is much stronger than its competitors. However, these features also have to pay a price. For example, additional complex operations, disk storage, memory loss, and so on must be added. If your hardware and software do not fully support SQL Server, I suggest you better choose other databases like DBMS, because you will get better results.   Security features  mysql has a binary log that is used to change data. Since it is binary, this log can quickly replicate data from the host to the client. Even if the server crashes, the twos log will remain intact and the copied portions will not be corrupted.   In SQL Server, you can also log queries about SQL, but this takes a high price.   Security   Both products have their own complete security mechanism. As long as you follow these security mechanisms, there is no problem with the general program. Both use the default IP port, but sometimes unfortunately, these IPs are also hacked into by some hackers. Of course, you can also set these IP ports yourself.   Resiliency: Advanced SQL Server   Resiliency is also a feature of MySQL, which is mainly shown in the MyISAM configuration. This approach has its inherent shortcomings, and if you accidentally damage the database, the results can result in all data loss. However, it is very stable for SQL Server. SQL Server can monitor the data exchange point at all times and can save the process of database corruption.   decide your choice as needed   for both databases, if you want me to say which one is better, maybe I'll let you down. In my opinion, any pair of databases that are helpful to your work are good databases, no database is absolutely excellent, and no database is absolutely bad. What I want to tell you is that you should start more from your own needs, that is, what kind of tasks do you want to accomplish? Instead of simply starting with the functionality of the software.   If you want to build a. NET Server system, this system can access data from many different platforms, participate in database management, then you can choose SQL Server. If you want to build a third-party site that can read data from some clients, MySQL will be the best choice.   Both databases can be in the. NET or Java EE, the same can be exploited by raid.  1, Advantage Analysis: MySQL short, easy to use, easy to operate, free of charge. Compared with other databases have the characteristics and practical syntax more. SQL is also a large database, stable, can do the general large system of data warehouse, running speed is significantly faster than MySQL (the advantage of huge data is obvious).  2, disadvantage analysis: MySQL difficult to assume the number of large systemsAccording to the warehouse, the running speed is slow, not stable enough, there is the situation of the drop line. Sql server Price is expensive (of course not say 5 yuan piracy), use is more difficult than MySQL, after all, things Big said more points.  3, according to your supplement (how to log in): MySQL has a text interface client, use up to say no mouse point convenient (but also accustomed to it), of course, matching MySQL has a professional client software, I am using SQLYOG519 version, various operations really is very convenient to say. sql server  log in with your own Query Analyzer:)   The premise is that the database service is open, and you need to know the user name password when installing:)  SQL-Server 2000  is a medium-sized database developed by Microsoft, it is very good at visualization, very powerful in terms of security, and has the strong technical support of Microsoft, of course, the price is more expensive, suitable for medium-sized systems.  mysql is  mysql. AB developed a small database, basically has all the functions required by the database, but the function is not sql-server strong, technical support also can't keep up, but the price is cheap, in the case of satisfying its license agreement can be used for free, suitable for small system.   languages are the same (SQL) is a structured query language.

This article is from "Ghost" blog, please make sure to keep this source http://caizi.blog.51cto.com/5234706/1547943

Talking about the difference between MySQL and SQL Server