This in-depth article introduces DB2 UDB products and their capabilities, discusses porting databases and applications, and describes the most important aspects of porting applications from Microsoft SQL Server 2000 to DB2 UDB V8. It describes the differences between the two products in database options, data definition language (DDL), data modeling, SQL considerations, data conversion, and application conversion.
If you're considering migrating to DB2® Universal Database™, you may be looking for information on exactly what's included in the DB2 UDB product family, and how its capabilities map to or compare with capabilities available in Microsoft® SQL Server.
This article introduces DB2 UDB products and their capabilities, discusses porting databases and applications, and describes the most important aspects of porting applications from Microsoft SQL Server 2000 to DB2 UDB V8. It describes the differences between the two products in database options, data definition language (DDL), data modeling, SQL considerations, data conversion, and application conversion.
Highlights include:
- Why port to DB2 UDB?
- DB2 Universal Database product family
- Data types conversion
- Administration issues
- Implementation differences
- Programming interfaces
- Terminology map
- DB2 CLI vs. ODBC function map
- Conversion tools
| Description | Name | Size | Download method |
|---|---|---|---|
| Article in PDF format | 0303rada.pdf | 525 KB | FTP |
Information about download methods Get Adobe® Reader®

Amyris Rada is the team lead for the i2 Product Integration Center at the IBM Toronto Lab. She provides technical expertise and guidance to the i2 PIC team in connection with the integration of IBM products, assisting in planning and testing i2 products for DB2, WebSphere, and AIX products. Amyris has held several positions over the past 10 years as a database consultant, developer, and administrator, and has published several white papers through the IBM developerWorks DB2 Web site.



