Comparing SQL Server 2005 and IBM DB2 v8.2 as a Database Platform
|
A well-known developer in the Visual Studio and Microsoft .NET community compares and contrasts SQL Server 2005 with IBM DB2 UDB 8.2, from the perspective of a Visual Studio 2005 developer. This study compares the core technologies used by both SQL Server 2005 and DB2 UDB 8.2, such as .NET Framework integration, support for language and other enhancements, and performance and manageability. The study also presents the steps necessary to build, debug, and deploy a stored procedure using SQL Server 2005. These steps are then compared to the steps required to build, debug, and deploy the same stored procedure using DB2. The intended audience for this article includes developers, architects, and technology decision-makers.
Included in this document:
| • | Summary of Study Results |
| • | Comparison of Core Technologies |
| • | Technical Walkthrough |
| • | Description of SQL Server 2005 CLR Stored Procedure |
| • | Building a Stored Procedure with SQL Server and Visual Studio 2005 |
| • | Description of a DB2 CLR Stored Procedure |
| • | Building a Stored Procedure with DB2 and Visual Studio |
| • | Summary Comparison of the Developer Experience |
| • | Beyond the Relational Database |
