So this is the difference between mysql and SqlServer.
sqlserver
Advantages:
Ease of use, scalability suitable for distributed organizations, data warehouse function for decision support, integration closely related to many other server software, good cost performance, etc.
It brings flexibility to data management and analysis, and allows companies to cope calmly in a rapidly changing environment, thus gaining a competitive advantage. From the point of view of data management and analysis, it is very important to turn raw data into business intelligence and make full use of the opportunities brought by the Web.
As a complete database and data analysis package, SQLServer opens the door for the rapid development of a new generation of enterprise-level business applications and for enterprises to win core competitive advantages.
As the record holder of the important benchmark scalability and speed award, SQLServer is a database product with full Web support, which provides the core support for Extensible Markup Language (XML) and the ability to query on the Internet and outside the firewall.
Disadvantages:
Openness: SQL Server can only run on windows without any openness. The stability of the operating system is very important to the database. Windows9X series products focus on desktop applications. NT server is only suitable for small enterprises, and the reliability, security and scalability of Windows platform are very limited. It has been tested like unix, especially for large databases.
Scalability parallelism: SQL server realizes parallel and * * * storage mode, which is relatively mature and difficult to cope with the increasing number of users and the limited scalability of data;
Security: No security certificate was obtained.
Performance: SQL Server has good performance when there are many users;
Client Support and Application Mode: Client Support and Application Mode. Only C/S mode is supported, and SQL Server C/S structure only supports windows clients to connect ADO, DAO, OLEDB and ODBC.
Use risk: SQL server completely rewrites the code and has experienced a long test delay. Many functions need time to prove and are very compatible.
relational database
Advantages:
Small size, high speed, low total cost of ownership and open source;
Support multiple operating systems;
Is an open source database, and the interface provided supports multilingual connection operation.
The core program of MySql is fully multithreaded. Threads are lightweight processes that can flexibly provide services to users without occupying too many system resources. MySql realized by multithreading and C language can easily make full use of CPU.
MySql has a very flexible and secure permissions and password system. When customers connect with MySql server, all password transmissions between them are encrypted, and MySql supports host authentication;
Support ODBC for Windows, support all ODBC 2.5 functions and other functions, connect MySql server with Access, and the application is extensible;
Support large databases, which can easily support databases with tens of millions of records. As an open source database, it can be modified for different applications.
Have a very fast and stable thread-based memory allocation system, which can be used continuously without worrying about its stability; ?
MySQL also provides a high degree of diversity, which can provide many different user interfaces, including command-line client operations, web browsers and various programming language interfaces, such as c++, Perl, Java, PHP, Python and so on.
You can use the pre-packaged client or write a suitable application yourself. MySQL can be used on Unix, Windows and OS/2 platforms, so it can be used on personal computers or servers.
Disadvantages:
Hot backup is not supported;
The biggest disadvantage of MySQL is that its security system is mainly complex rather than standard, and it will only change when calling mysqladmin to reread user permissions.
There is no stored procedure language, which is the biggest limitation for programmers who are used to enterprise databases.
The price of MySQL varies depending on the platform and installation method. MySQL for Linux is free if it is installed by the user himself or the system administrator, but not by a third party, and the third party solution must pay the license fee. Unix or Linux installation is free, and Unix or Linux third-party installation is charged.