Compare IBM Db2 Database vs. SQL Server

Cancel
You must select at least 2 products to compare!
IBM Db2 Database Logo
12,518 views|9,611 comparisons
SQL Server Logo
23,836 views|20,286 comparisons
Most Helpful Review
Find out what your peers are saying about IBM Db2 Database vs. SQL Server and other solutions. Updated: September 2020.
442,517 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"Some of the most valuable features are the scaling from a small very cheap installation to a very large enterprise installation. In addition, the backups and assistance are good.""The most valuable feature of this solution is the integration with other IBM products.""The scalability and availability of this solution are the most valuable features.""The most valuable features of this solution are security and stability.""The solution is very stable, in both hardware and database.""The self-management and optimization features are probably the best on the market""We had a crash of the backup system and the IBM DB2 was always up and consistent. It's robust, and for us, it was always up and running.""When you submit a ticket the response time is quick."

More IBM Db2 Database Pros »

"I have experience with this product for many years. I never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient.""It is one of the most stable relational databases out there.""The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.""The availability is the most valuable feature. It has high availability. It also has good performance.""SQL is very easy to manage.""It helps with moving the design of the database into reality.""The feature that I have found most valuable is that it is easy to code.""Very good security features."

More SQL Server Pros »

Cons
"The initial set up was complex.""I would like to see better support for advanced analytics.""It would be helpful to have more querying tools and more development tools for us to work easily with Microsoft.""End-to-end encryption specifically is something the solution needs to have in the next release.""The ease of use, or ease of management, could be improved.""The licensing fees can be reduced.""The price should be lower.""In terms of improvements, IBM Db2 can improve its interface and its functionality. Also, the embedded functions should be much richer than the current ones - the functions which are embedded in the engine itself."

More IBM Db2 Database Cons »

"It would be nice if there was a feature to search for a specific value across multiple tables. This would save a lot of time for its users.""I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins.""I would like to have more replication scenarios.""In terms of improvement, it could use more integration with other products.""Occasionally the performance, as good as it is, is a bit off. We sometimes experience memory spiking. If they could maybe fix that aspect of the solution, that would be quite helpful for our organization.""The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient.""In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages.""Query optimitzer could be simplified."

More SQL Server Cons »

Pricing and Cost Advice
"Licensing fees are on a yearly basis.""We don't see what the specific price of the DB2 license is because we pay for the backup license as a package.""I think that everyone knows that with IBM the standard price is higher than the others.""Db2 is less expensive than Oracle."

More IBM Db2 Database Pricing and Cost Advice »

"It is expensive, but you get what you pay for.""Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can typically sell from around $1000 dollars a month, which is not cheap. Then, there is an additional one-time Windows cost, based on the code, which can go anywhere from $30,000 to $40,000 for the license.""SQL Server is a cost-effective solution for a small database.""Pricing is reasonable for small organizations, but the scaling increases the price."

More SQL Server Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
442,517 professionals have used our research since 2012.
Questions from the Community
Top Answer: Per all previous posts "it depends". Platform, type of use and ability to be stable for the work-load are the concerns. Finding Oracle skills vs DB2 skills in the mainframe world is an area where… more »
Top Answer: Very good for performance and scalability.
Top Answer: IBM Db2 was much cheaper as a package than using other products. This is because IBM supplied a package with its product. It's an application. So it was much more efficient and a stronger competitor… more »
Top Answer: The availability is the most valuable feature. It has high availability. It also has good performance.
Top Answer: In terms of improvement, it could use more integration with other products.
Top Answer: My primary use case is for data mining and processing data from plants. It's normally just for databases for the systems.
Ranking
5th
Views
12,518
Comparisons
9,611
Reviews
14
Average Words per Review
488
Avg. Rating
7.7
1st
Views
23,836
Comparisons
20,286
Reviews
16
Average Words per Review
439
Avg. Rating
8.1
Popular Comparisons
Compared 31% of the time.
Compared 12% of the time.
Compared 6% of the time.
Compared 5% of the time.
Compared 17% of the time.
Compared 14% of the time.
Compared 13% of the time.
Compared 7% of the time.
Also Known As
DB2Microsoft SQL Server, MSSQL, MS SQL
Learn
IBM
Microsoft
Overview
DB2 Enterprise for Linux, UNIX, and Windows is the ideal data server for the most demanding workloads. New XML support is designed to help firms minimize the time and effort it takes to persist and use their XML data reducing development costs and improving business agility.

SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

Offer
Learn more about IBM Db2 Database
Learn more about SQL Server
Sample Customers
Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of TorontoMicrosoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Top Industries
REVIEWERS
Financial Services Firm44%
Insurance Company19%
University13%
Transportation Company6%
VISITORS READING REVIEWS
Computer Software Company36%
Comms Service Provider11%
Insurance Company8%
Financial Services Firm8%
REVIEWERS
Computer Software Company13%
Financial Services Firm10%
Manufacturing Company10%
Non Profit7%
VISITORS READING REVIEWS
Computer Software Company34%
Comms Service Provider13%
Media Company8%
Retailer5%
Company Size
REVIEWERS
Small Business25%
Midsize Enterprise13%
Large Enterprise63%
REVIEWERS
Small Business35%
Midsize Enterprise28%
Large Enterprise37%
Find out what your peers are saying about IBM Db2 Database vs. SQL Server and other solutions. Updated: September 2020.
442,517 professionals have used our research since 2012.
IBM Db2 Database is ranked 5th in Relational Databases with 14 reviews while SQL Server is ranked 1st in Relational Databases with 16 reviews. IBM Db2 Database is rated 7.8, while SQL Server is rated 8.2. The top reviewer of IBM Db2 Database writes "Almost maintenance-free and less expensive, but lacking in the area of development tools and resources". On the other hand, the top reviewer of SQL Server writes "Stable with a straightforward setup and the capability to scale". IBM Db2 Database is most compared with Oracle Database, MySQL, SAP HANA, Teradata and IBM Netezza Performance Server, whereas SQL Server is most compared with SAP HANA, Teradata, Oracle Database, MariaDB and IBM Netezza Performance Server. See our IBM Db2 Database vs. SQL Server report.

See our list of best Relational Databases vendors.

We monitor all Relational Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.