SQL Server 2008 vs. IBM DB2

Microsoft SQL Server 2008 delivers better performance and scalability, high efficiency, industry-leading security, easier management, increased developer productivity, leading business intelligence and data warehousing capabilities, a platform for host OLTP and SAP integration- All of this is provided at a lower total cost of ownership than IBM DB2. Based on this, many companies migrate from DB2 to SQL Server. SQL Server currently accounts for a higher share of the new relational database management system license market than DB2.

In contrast

· Total cost of ownership (TCO) and ROI

· Performance and Scalability

· High effectiveness

· Security

· Management capacity

· Developer Productivity

· Business Intelligence and Data warehousing

· Oltp

· SAP integration

Porting cases

· Scandinavian Airlines

Scandinavian Airlines migrate data warehouses to SQL Server, improving access to business data and reducing costs by 50%.

· The progressive Group

The progressive group improves business agility by porting to SQL Server.

· Bovespa

BOVESPA: Brazilian Stock Exchange porting to SQL Server makes it possible to handle 110,000 transactions per day worth $ billion.

· Danske Supermarket

A Danske supermarket with 100 stores will migrate the profiling database from DB2 to SQL Server.

· Insurance company

An insurance company migrated from DB2 to SQL Server, making costs less expensive and more scalable.

· Indiana University

Indiana University migration from DB2 to SQL Server found better management capabilities and performance.

TCO and ROI

· Initial acquisition cost is lower than IBM DB2. SQL Server's ultra-high cost performance lowers hardware costs.

· SQL Server 2008 automates, streamlines, or eliminates many of the common database management costs, making the database management cost less than IBM DB2.

· SQL Server 2008 contains features that DB2 users must purchase with additional plug-ins, including: All business intelligence, reporting, analytics, ETL, XML functionality, data warehousing, security, and performance optimization.

· The cost of SQL Server licenses is lower than IBM DB2, reducing its future TCO and increasing its ROI. DB2 licenses may cost 5-6 times more than SQL Server, and multiple-core licenses cost more than a few times.

o SAP TCO Research by comparing SQL Server with other databases, the results show that customers reduce the cost of database administrators by 55%, reducing total TCO by 37%.

Case study: Customers prefer to choose SQL Server instead of DB2

· Borgata Hotel Casino & Spa, the first casino in Atlantic City, improves operational efficiencies and saves $400,000 by using SQL Server.

· The Alaska State Tax department chose SQL Server instead of DB2 to build a 7TB Data warehouse for Alaska State.

· National Savings Bank of Serbia (NSBS) has chosen SQL Server instead of DB2 to deploy complex banking business intelligence solutions.