1, running on different platforms.

Oracle can run on all mainstream platforms, and the Oracle database adopts open strategic objectives, enabling customers to choose the solution that best suits their specific needs. Customers can use a variety of third-party applications and tools. But SQL Server can only run on Windows.

2, the security is different

Oracle's security certification has obtained the ISO standard certification with the highest certification level, while SQL Server has not obtained any security certification. This proves that the security of Oracle is higher than that of SQL Server.

3, the performance is different

SQL Server has poor performance when it is multi-user, while Oracle has the highest performance, keeping the world records of TPC-D and TPC-C under windowsNT.

4. Different stylistic structures

Oracle Bone Inscriptions? The file structure of is: data file. Dbf (real data, log file. Rdo, control file. Parameter file. Ola.

SQL Server？ The file architecture of is. Data dictionary. Ndf (data file) and. Log file.

5. Different client support and application modes.

SQL Server C/S structure only supports windows customers, and can connect ADO, DAO, OLEDB and ODBC.

Oracle multi-level network computing supports various industrial standards and can connect with network customers such as odbc, JDBC and OCI.

Baidu Encyclopedia-Microsoft SQL Server

Baidu Encyclopedia -—Oracle Database