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

Compare IBM Db2 and Microsoft SQL Server

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
IBM Db2
IBM Db2
Star Rating
(678)4.1 out of 5
Market Segments
Enterprise (66.0% of reviews)
Information
Entry-Level Pricing
Free Trial 1 License
Browse all 6 pricing plans
Microsoft SQL Server
Microsoft SQL Server
Star Rating
(2,252)4.4 out of 5
Market Segments
Enterprise (45.6% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL Server
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that Microsoft SQL Server excels in Data Quality with a score of 8.7, while IBM Db2 trails slightly behind at 8.3. Reviewers mention that SQL Server's built-in tools for data validation and cleansing are particularly effective.
  • Reviewers mention that Microsoft SQL Server's Query Language is highly rated at 9.2, compared to IBM Db2's 8.3. Users say that SQL Server's T-SQL offers more intuitive syntax and better support for complex queries, making it easier for developers to work with.
  • G2 users highlight that Microsoft SQL Server's Backup and Recovery features are top-notch, scoring 9.0, while IBM Db2's score of 8.6 indicates room for improvement. Users report that SQL Server's automated backup options provide peace of mind and reliability.
  • Users on G2 report that Microsoft SQL Server's Data Replication capabilities are superior, with a score of 8.8, compared to IBM Db2's 8.5. Reviewers mention that SQL Server's replication options are more flexible and easier to configure.
  • Reviewers mention that IBM Db2 shines in Data Distribution, scoring 9.0, while Microsoft SQL Server scores 8.9. Users say that Db2's ability to efficiently manage data across distributed environments is a significant advantage for large enterprises.
  • Users report that Microsoft SQL Server's Performance Analysis tools are highly effective, scoring 8.9, while IBM Db2's tools are rated slightly lower at 8.5. Reviewers mention that SQL Server's built-in performance tuning features help optimize database operations seamlessly.
Pricing
Entry-Level Pricing
IBM Db2
Db2 On Cloud - Lite
Free Trial
1 License
Browse all 6 pricing plans
Microsoft SQL Server
No pricing available
Free Trial
IBM Db2
Free Trial is available
Microsoft SQL Server
No trial information available
Ratings
Meets Requirements
8.5
484
9.0
1,847
Ease of Use
8.0
493
8.6
1,863
Ease of Setup
7.7
259
8.1
984
Ease of Admin
7.7
241
8.3
945
Quality of Support
8.1
457
8.3
1,641
Has the product been a good partner in doing business?
8.3
234
8.4
895
Product Direction (% positive)
6.8
452
8.4
1,818
Features by Category
8.2
63
Not enough data
Data Management
8.6
52
|
Verified
Not enough data
8.1
48
|
Verified
Not enough data
8.6
49
|
Verified
Not enough data
8.2
48
|
Verified
Not enough data
7.5
34
|
Verified
Not enough data
7.6
34
|
Verified
Not enough data
Integration
7.8
43
|
Verified
Not enough data
8.1
45
|
Verified
Not enough data
8.1
42
|
Verified
Not enough data
Deployment
8.4
50
|
Verified
Not enough data
7.8
41
|
Verified
Not enough data
Performance
8.6
51
|
Verified
Not enough data
Security
8.7
46
|
Verified
Not enough data
9.0
35
|
Verified
Not enough data
Generative AI
8.3
8
Not enough data
8.3
8
Not enough data
Database Management Systems (DBMS)Hide 10 FeaturesShow 10 Features
Not enough data
9.0
163
Management
Not enough data
8.9
150
Not enough data
8.9
150
Not enough data
9.2
155
Not enough data
8.9
150
Not enough data
8.9
152
Maintenance
Not enough data
8.9
150
Not enough data
9.0
155
Not enough data
9.0
151
Security
Not enough data
8.9
149
Not enough data
9.1
151
8.5
368
8.9
1,434
Management
8.6
59
9.1
147
8.4
61
9.2
148
8.2
51
8.8
134
8.5
54
8.9
140
Support
8.0
56
8.6
143
8.4
59
9.1
147
7.9
59
8.7
142
8.3
60
8.5
146
Security
8.5
59
8.9
146
8.8
59
9.1
146
8.4
57
8.9
143
8.4
55
9.0
146
Performance
8.6
59
8.8
142
8.6
57
8.9
139
8.5
55
8.8
145
8.4
56
8.7
143
8.4
56
8.9
144
Database Features
8.7
304
8.9
1282
8.8
306
9.0
1287
8.8
306
8.9
1294
8.4
302
8.7
1261
8.8
301
8.8
1263
8.4
302
8.8
1269
8.4
307
9.1
1289
Data Warehouse AutomationHide 11 FeaturesShow 11 Features
8.0
11
Not enough data
Automation
8.3
9
Not enough data
8.1
9
Not enough data
8.3
9
Not enough data
8.5
9
Not enough data
Functionality
7.4
9
Not enough data
8.1
9
Not enough data
8.0
9
Not enough data
Administration
8.3
8
Not enough data
7.7
8
Not enough data
7.7
8
Not enough data
Agentic AI - Data Warehouse Automation
Not enough data
Not enough data
Database as a Service (DBaaS)Hide 17 FeaturesShow 17 Features
8.7
77
Not enough data
Configuration
8.5
65
Not enough data
8.1
60
Not enough data
8.5
65
Not enough data
8.3
61
Not enough data
8.6
62
Not enough data
Database Administration
8.6
60
Not enough data
8.8
60
Not enough data
8.8
59
Not enough data
Availability
8.9
62
Not enough data
9.1
62
Not enough data
8.8
63
Not enough data
8.9
63
Not enough data
Security
8.4
41
Not enough data
8.8
42
Not enough data
8.8
40
Not enough data
Data Management
8.7
45
Not enough data
8.6
44
Not enough data
Big Data Processing and DistributionHide 10 FeaturesShow 10 Features
Not enough data
8.4
57
Database
Not enough data
8.6
55
Not enough data
8.8
56
Not enough data
8.4
53
Integrations
Not enough data
7.8
44
Not enough data
8.3
44
Platform
Not enough data
8.3
49
Not enough data
8.6
52
Not enough data
8.3
44
Processing
Not enough data
8.6
51
Not enough data
8.5
54
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
8.7
364
Not enough data
Database Features
8.7
304
8.9
1282
8.8
306
9.0
1287
8.8
306
8.9
1294
8.4
302
8.7
1261
8.8
301
8.8
1263
8.4
302
8.8
1269
8.4
307
9.1
1289
Categories
Categories
Shared Categories
IBM Db2
IBM Db2
Microsoft SQL Server
Microsoft SQL Server
IBM Db2 and Microsoft SQL Server are categorized as Relational Databases
Reviews
Reviewers' Company Size
IBM Db2
IBM Db2
Small-Business(50 or fewer emp.)
13.7%
Mid-Market(51-1000 emp.)
20.3%
Enterprise(> 1000 emp.)
66.0%
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.6%
Reviewers' Industry
IBM Db2
IBM Db2
Information Technology and Services
21.6%
Banking
11.6%
Computer Software
10.1%
Financial Services
7.3%
Insurance
5.9%
Other
43.5%
Microsoft SQL Server
Microsoft SQL Server
Information Technology and Services
24.2%
Computer Software
13.7%
Hospital & Health Care
5.4%
Financial Services
4.3%
Higher Education
2.9%
Other
49.6%
Alternatives
IBM Db2
IBM Db2 Alternatives
Oracle Database
Oracle Database
Add Oracle Database
Amazon Relational Database Service (RDS)
Amazon Relational Database Service (RDS)
Add Amazon Relational Database Service (RDS)
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Teradata Vantage
Teradata Vantage
Add Teradata Vantage
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
Discussions
IBM Db2
IBM Db2 Discussions
Where can I find answers to other questions I may have?
2 Comments
Official Response from IBM Db2
Please visit: https://developer.ibm.com/answers/questions/436870/common-questions-about-the-db2-on-cloud-free-plan/Read more
I want to replace KDB+ with DB2 BLU, before doing this in my project, i want to know following answers. 1. Is DB2 BLU , capable for this type of achievement which KDB+ do? 2. can you please give me a list comparison between DB2 BLU with KDB+?
1 Comment
Nuno O.
NO
Please check: https://db-engines.com/en/system/IBM+Db2%3BKdb%2B Read more
Which tool do you use for deep monitoring of IBM DB2 databases (instances) ?
1 Comment
Matthias F.
MF
Maxim, we have a dedicated management console that comes free with Db2. It was called Data Server Manager in the past, now we call it the Unified Management...Read more
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