Integrate SQL Server 2000 and IBM DB2

Published: November 26, 2002

SQL Server Product Managers Adam Carroll and Al Hilwa explore some common misconceptions regarding IBM DB2 and compare IBM DB2 version 8.1 to SQL Server 2000. To view these videos, you'll need Windows Media Player.

ResourcesTopic SamplesDownload or View File

Part 1:
Introduction

Microsoft's Adam Carroll and Al Hilwa introduce the topics of comparison between IBM DB2 and SQL Server 2000.

Introduction

Part 2:
Different DB2s for Different DBAs

Many customers assume that IBM DB2 is a single product, but there are a number of IBM DB2 products with different storage architectures, error messages, and structured query language (SQL) syntax.

Different DB2s for Different DBAs

Part 3:
Scalability and Applications

Though known to scale well on the mainframe, not all IBM DB2 environments are equally scalable; and while the mainframe is a good workload consolidation environment, it has few performance proof points running modern-day application architectures.

Scalability and Applications

Part 4:
Business Intelligence and Data Warehousing

IBM DB2 is known to run centralized data warehouses through a partitioned database architecture that is difficult to plan for, install, and manage.

Business Intelligence and Data Warehousing

Part 5:
IBM DB2 Version 8.1 Manageability and Tools

IBM provides tools to address inherent complexities in IBM DB2, rather than providing automatic or truly self-managing features.

IBM DB2 Version 8.1 Manageability and Tools

Part 6:
IBM DB2 Version 8.1 Pricing, Packaging, and 64-bit Support

IBM has made some product packaging changes with minimal implications for customers but the price increases of the enterprise edition are significant.

IBM DB2 Version 8.1 Pricing, Packaging, and 64-bit Support

Part 7:
Developer Features

IBM DB2 has a way to go in terms of natively supporting SQL stored procedures, whereas Microsoft SQL Server has supported SQL stored procedures from version 1.0.

Developer Features


Top of pageTop of page