All the differences between MySQL and SQL Server

Source: Internet
Author: User
Tags command line mssql sql mysql net window access visual studio
The official name of MSSQL is from SQL Server MS Company. The graphics operation interface is better, the performance is also OK. Cannot be interchanged on MSSQL and Oracle. Supports OLE DB connections. asp, MSSAQL only for window MySQL is mysql below is the Readme: Free software. Performance is also possible. Fast, for small scale. Command line interface. (Can be installed graphics operating software.)

SQL Server I used to use it when I was an ASP.
Now learn PHP. It goes with MySQL. It feels pretty good. Easy to operate, powerful.

Driver not the same field type

MySQL has full permissions control, full TCP protocol support, can be accessed across the web, as long as the structure is well designed, MySQL is a set of very valuable and database systems, but does not support foreign keys, does not support transactions, does not support stored procedures, do not support triggers. Full-text search is even less, except for Windows edition to pay, other platforms are free, you can understand it as a user-controlled Access database. The biggest feature of its popularity is that Php+mysql is free, and cross-platform, on the contrary, how much would it cost to use Asp+mssql?

The paging difference is different when the SQL statement gets the total number of records.
Select COUNT (*) from Guestbook; Mssql
Select name from note; Mysql

MySQL is an open source database, smaller, but functional and fast. Much better than access.

SQL Server,mssql is also it. It's a database from Microsoft. Very large, powerful.

For program developers, the two most popular background databases are MySQL and SQL Server. The basic similarity between the two is the data storage and 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 speeds up the query. At the same time, both provide various formats that support XML. Apart from the obvious difference in the price of software, what is the obvious difference between the two products? How do you choose between the two? Let's look at the major differences between the two products, including release fees, performance, and their security.

The fundamental difference is the basic principles they follow.

The basic principles they follow are the main differences: openness vs conservatism. The narrow, conservative storage engine of the SQL Server is extensible with the MySQL server, and the open storage engine is very different. While you can use the SQL Server's Sybase engine, 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 some of the functionality of the storage program, such as the MyISAM engine to support switching capabilities.

Issue fee: MySQL is not all free, but very cheap

When it comes to the cost of distribution, the two products use two very different decisions. For SQL Servers, the most common way to get a free development fee is to purchase Microsoft Office or Visual Studio costs. However, if you want to use the commercial product development, you must also purchase the SQL Server Standard Edition. Schools or non-profit enterprises may not consider this additional cost.

Performance: Advanced MySQL

MySQL is pretty good for performance purely because it contains a default desktop format, MyISAM. The MyISAM database is very compatible with disk and does not consume too much CPU and memory. MySQL can run on the Windows system without conflict, and it is better to run on UNIX or similar UNIX systems. You can also use a 64-bit processor to get some extra performance. Because MySQL uses 64-bit integer processing in many cases internally. Yahoo! Commercial website uses MySQL as the background database.

When it comes to software performance, SQL Server stability is much stronger than its competitors. However, these characteristics 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 DBMS databases, because you will get better results.

Security features

MySQL has a binary log that changes data. Because 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 is a high price to pay.

Security

Both of these products have their own complete security mechanisms. As long as you follow these security mechanisms, there will be 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 up these IP ports yourself.

recoverability: Advanced SQL Server

Recoverability is also a feature of MySQL, which is mainly manifested in the MyISAM configuration. This approach has its inherent imperfections, and if you accidentally damage the database, the results may result in all data loss. However, the SQL Server is a very stable key. The SQL Server is able to monitor data exchange points at all times and to preserve the process of database corruption.

Decide your choice as needed

For both of these databases, I might disappoint you if I had to say which one is better. In my opinion, any database that helps you with 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 with your own needs, that is, what kind of task do you want to accomplish? Instead of simply starting with the function 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, this site can read data from some clients, then MySQL will be the best choice.

Both databases can be in the. NET or Java-EE operation is normal, the same, can use RAID.

The day did not notice, use SELECT top x when MySQL does not recognize, although no top x is not not, but always feel awkward, and later found that the original is in MySQL, need to use LIMIT X to limit.
X represents a Non-zero positive integer. This may be the so-called "SQL dialect" seen in the hibernate. Different databases, the SQL language will be a little different.

MySQL: free, cross-platform, but less functional only database,table, user management These, make for small database, medium also barely can

MSSQL: To Buy, can only be built on window, including the above features and view,procedure,trigger,job ... Too much, suitable for the small and medium-sized database, large is barely a bit



Related Article

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.