Oracle vs SQL Server

with the constant change of learning knowledge, in order to use a variety of learning needs, the contact of different data processing database is also many for SQL is full of emotion, because the. NET system is to borrow SQL to store our data, and for Oracle's first meeting, many have known each other, in fact, the things are very much the same, just show slightly different:

< a > practical environment

Under normal circumstances:

Small database	Medium Database	Large database
Access, Foxbase	Mysql SQL Server	Sybase Oracle DB2

< two > main differences

Open

SQL Server is a database management system launched by Microsoft Corporation, with no openness and can only serve Microsoft. Oracle is Oracle's relational database management system, capable of running on all platforms and fully supporting all industry standards. Adopt a fully open strategy to meet the needs of users.

Performance

SQL Server Multi-user performance is poor, Oracle can meet the needs of multi-user operations,

Operating conditions

The operation process is different, SQL Server executes the SQL statement on the intrinsic page, the operation is simple; Oracle is called complex and provides both GUI and command line.

Risk

SQL Server completely rewritten the code and went through a long period of testing, but it was not compatible with some of the earlier works; Oracle's long-time development experience is completely backwards compatible. Are widely used, without risk at all.

< three > future prospects

For their own use of what database, in fact, as long as the use of their own convenience, on their own projects are suitable in fact on the line! such as the examination system, the authority system, and so on, SQL Server can fully meet our needs, just look at the degree of post-optimization is not using tools such as EF to meet the speed.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Oracle vs SQL Server