As for the difference between SqlServer and Oracle:
1. Openness 1. SQL Server can only run on windows without any openness, and the stability of the operating system is very important for the database. Windows9X series products are mainly desktop applications, and NT server is only suitable for small and medium-sized enterprises. Moreover, the reliability, security and expansibility of windows platform are very limited. It is not tested like unix, especially when dealing with large databases. 2.Oracle can run on all major platforms (including windows). Fully support all industrial standards. Adopt a completely open strategy. Allow customers to choose the most suitable solution. Give full support to developers.
Second, scalability and parallelism 1. The parallel implementation and * * * storage mode of SQL server are immature, so it is difficult to handle the increasing number of users and data, and its scalability is limited. 2.Oracle parallel server extends the capability of windownt by letting a group of nodes * * * enjoy their work in the same cluster, and provides a cluster solution with high availability and high scalability. If windowsNT can't meet the needs, users can migrate the database to UNIX. Oracle's parallel server is highly integrated with the cluster mechanism of various UNIX platforms.
Third, the performance is 1. When there are many users, the performance of SQL Server is not good. 2.Oracle has the highest performance, keeping the world records of TPC-D and TPC-C under the open platform.
Fourth, the client support and application mode is 1. SQL Server C/S structure only supports windows customers and can be connected through ADO, DAO, OLEDB and ODBC. 2.Oracle multi-level network computing supports various industrial standards and can connect with network customers such as ODBC, JDBC and OCI.
Verb (abbreviation of verb) simple operation 1. SQL Server is simple to operate, but only has a graphical interface. 2.Oracle is more complicated, providing both GUI and command line, and the operation is the same under windowsNT and unix.
Sixth, use risk 1 completely rewritten code. SQL server has experienced a long time of testing and constant delay, and many functions need time to prove. Not quite in tune. 2.Oracle's long-term development experience is completely backward compatible. It has been widely used. There is no risk at all. ORACLE is more expensive than SQLSRVER in the final price.