[go: up one dir, main page]

Introducing G2.ai, the future of software buying.Try now

Compare Microsoft SQL Server and Oracle Database

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Microsoft SQL Server
Microsoft SQL Server
Star Rating
(2,249)4.4 out of 5
Market Segments
Enterprise (45.5% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL Server
Oracle Database
Oracle Database
Star Rating
(980)4.3 out of 5
Market Segments
Enterprise (61.0% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Oracle Database
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that Microsoft SQL Server excels in Query Language with a score of 9.2, which reviewers mention makes it easier to write complex queries compared to Oracle Database's score of 8.9.
  • Reviewers say that Microsoft SQL Server's Data Migration feature is highly rated at 9.0, making it a preferred choice for organizations looking to transition smoothly, while Oracle Database's migration capabilities are perceived as slightly less efficient.
  • G2 users highlight that Microsoft SQL Server offers superior Ease of Setup with a score of 8.1, which is beneficial for teams with limited technical expertise, whereas Oracle Database's setup process is noted to be more challenging with a score of 7.5.
  • Users on G2 mention that Microsoft SQL Server's Backup and Recovery features are robust, scoring 9.0, which is crucial for data integrity, while Oracle Database's backup solutions, although effective, received a slightly lower score of 8.5.
  • Reviewers mention that Microsoft SQL Server's Performance Analysis tools are highly rated at 8.9, providing valuable insights for optimization, whereas Oracle Database's performance tools are seen as less intuitive, scoring 8.7.
  • Users say that Microsoft SQL Server's User Access Control is rated at 9.1, which reviewers appreciate for its granularity and ease of management, while Oracle Database's access control features, although secure, received a lower score of 8.6, indicating room for improvement.
Pricing
Entry-Level Pricing
Microsoft SQL Server
No pricing available
Oracle Database
No pricing available
Free Trial
Microsoft SQL Server
No trial information available
Oracle Database
No trial information available
Ratings
Meets Requirements
9.0
1,846
9.0
703
Ease of Use
8.6
1,860
8.3
708
Ease of Setup
8.1
981
7.6
364
Ease of Admin
8.3
943
7.8
324
Quality of Support
8.3
1,640
8.3
674
Has the product been a good partner in doing business?
8.4
893
8.1
326
Product Direction (% positive)
8.4
1,816
8.2
672
Features by Category
Database Management Systems (DBMS)Hide 10 FeaturesShow 10 Features
9.0
162
Not enough data
Management
8.9
151
Not enough data
8.9
150
Not enough data
9.2
156
Not enough data
8.9
151
Not enough data
8.9
153
Not enough data
Maintenance
8.9
151
Not enough data
9.0
156
Not enough data
9.0
152
Not enough data
Security
8.9
150
Not enough data
9.1
152
Not enough data
8.9
1,432
8.8
555
Management
9.1
147
9.0
138
9.3
148
8.9
140
8.8
134
8.8
123
8.9
140
8.8
133
Support
8.6
143
8.4
135
9.0
147
8.9
138
8.7
142
8.7
136
8.5
146
8.7
134
Security
8.9
146
8.7
136
9.1
146
8.7
138
8.9
143
8.7
131
9.0
146
8.8
137
Performance
8.8
142
8.6
133
8.9
139
8.7
132
8.8
145
8.5
132
8.7
143
8.7
135
8.9
144
8.8
139
Database Features
8.9
1281
9.0
489
9.0
1286
9.0
491
8.9
1293
8.8
496
8.7
1260
8.7
488
8.8
1262
9.0
488
8.8
1269
8.7
481
9.1
1289
8.9
490
Database as a Service (DBaaS)Hide 17 FeaturesShow 17 Features
Not enough data
8.7
95
Configuration
Not enough data
8.7
91
Not enough data
8.3
87
Not enough data
8.6
89
Not enough data
8.4
84
Not enough data
8.9
88
Database Administration
Not enough data
8.5
85
Not enough data
8.8
83
Not enough data
8.9
85
Availability
Not enough data
8.9
87
Not enough data
9.0
89
Not enough data
8.8
83
Not enough data
8.7
84
Security
Not enough data
8.8
86
Not enough data
8.6
83
Not enough data
8.7
80
Data Management
Not enough data
8.9
81
Not enough data
8.7
80
Big Data Processing and DistributionHide 10 FeaturesShow 10 Features
8.4
57
Not enough data
Database
8.6
55
Not enough data
8.8
56
Not enough data
8.4
53
Not enough data
Integrations
7.8
44
Not enough data
8.3
44
Not enough data
Platform
8.3
49
Not enough data
8.6
52
Not enough data
8.3
44
Not enough data
Processing
8.6
51
Not enough data
8.5
54
Not enough data
Not enough data
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Microsoft SQL Server
Microsoft SQL Server
Oracle Database
Oracle Database
Microsoft SQL Server and Oracle Database are categorized as Relational Databases
Unique Categories
Oracle Database
Oracle Database is categorized as Database as a Service (DBaaS)
Reviews
Reviewers' Company Size
Microsoft SQL Server
Microsoft SQL Server
Small-Business(50 or fewer emp.)
18.4%
Mid-Market(51-1000 emp.)
36.1%
Enterprise(> 1000 emp.)
45.5%
Oracle Database
Oracle Database
Small-Business(50 or fewer emp.)
11.9%
Mid-Market(51-1000 emp.)
27.1%
Enterprise(> 1000 emp.)
61.0%
Reviewers' Industry
Microsoft SQL Server
Microsoft SQL Server
Information Technology and Services
24.1%
Computer Software
13.7%
Hospital & Health Care
5.5%
Financial Services
4.3%
Higher Education
2.9%
Other
49.6%
Oracle Database
Oracle Database
Information Technology and Services
20.7%
Computer Software
11.6%
Financial Services
5.6%
Banking
5.1%
Hospital & Health Care
4.3%
Other
52.6%
Most Helpful Reviews
Microsoft SQL Server
Microsoft SQL Server
Most Helpful Favorable Review
Elizabeth G.
EG
Elizabeth G.
Verified User in Information Technology and Services

For my use cases, microsoft sql has been pretty cooperative.

Most Helpful Critical Review
Scott T.
ST
Scott T.
Verified User in Primary/Secondary Education

cost if you need to expand. tied to windows servers which are getting less and less reliable.

Oracle Database
Oracle Database
Most Helpful Favorable Review
Tapan J.
TJ
Tapan J.
Verified User in Marketing and Advertising

Oracle latest versions are memory efficient with advance compression on the fly built in so that a huge investment in terms of disk space is saved.Oracle allows data to be controlled from a central repository. A DBA is responsible to create users, assign...

Most Helpful Critical Review
Matthew S.
MS
Matthew S.
Verified User in Computer Software

The standard command line tool is terrible. The cost is very high making it a feasible option for enterprise and full scale applications only.

Alternatives
Microsoft SQL Server
Microsoft SQL Server Alternatives
Teradata Vantage
Teradata Vantage
Add Teradata Vantage
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Google Cloud SQL
Cloud SQL
Add Google Cloud SQL
Snowflake
Snowflake
Add Snowflake
Oracle Database
Oracle Database Alternatives
Amazon Relational Database Service (RDS)
Amazon Relational Database Service (RDS)
Add Amazon Relational Database Service (RDS)
IBM Db2
IBM Db2
Add IBM Db2
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Amazon Aurora
Amazon Aurora
Add Amazon Aurora
Discussions
Microsoft SQL Server
Microsoft SQL Server Discussions
How could I make much easier the experience with the order of my database?
4 Comments
Afolabi F.
AF
You can create different tables with your employee information eg employee table, employee roles etc. Then you can create a single view that will pull data...Read more
What is the best way to save your queries?
4 Comments
CA
I recommend that you use the saved querys in plain text or .sql or txt format you can use the same sql server query creator or a notepad +++ tool, they are...Read more
How can I work on the same query if the connection is lost (timeout) and then I reconnect?
4 Comments
JE
When this happens to me in SQL Server Management Studio, I just have to type USE {your database name here} and then select only that statement and execute...Read more
Oracle Database
Oracle Database Discussions
What is Oracle Database used for?
2 Comments
Abid Hussain A.
AA
Oracle Database is a relational database management system (RDBMS) that is widely used in the industry for managing and storing large volumes of data. It...Read more
What is the solution for extracting pdf data stored in DB in clob format
1 Comment
walter g.
WG
try APEXRead more
Why oracles was not up the mark in mobile arena.
1 Comment
walter g.
WG
All Oracle products have mobile versions. For development, try APEX.Read more