 | Level: Introductory Amyris Rada (arada@ca.ibm.com), Team Lead, i2 Partner Integration Center, IBM Toronto Lab
27 Jan 2005
Updated 11 Jul 2005 Learn all about the DB2® UDB™ product family in this article that discusses porting databases and applications and describes the most important aspects of porting applications from Microsoft® SQL Server 2000 to DB2 UDB V8.2. You'll discover the differences between the two products in database options, data definition language (DDL), data modeling, SQL considerations, data conversion, and application conversion.
Database management software is now the core of enterprise computing. Companies need access to a wide range of information such as XML documents, streaming video, and other rich media types. New ways of working bring new requirements, including digital rights management. The e-business evolution makes continuous availability a necessity and is driving the convergence of transaction, business intelligence, and content management applications as companies integrate their business operations. DB2 Universal Database (DB2 UDB) for UNIX® and Windows® can help your organization meet these challenges.
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.2. It describes the differences between the two products in database options, data definition language (DDL), data modeling, SQL considerations, data conversion, and application conversion.
The topics under discussion in this article include:
- Why port to DB2 UDB?
- DB2 UDB product family
- Data types conversion
- Administration issues
- Implementation differences
- Programming interfaces
- DB2 CLI vs. ODBC function maps
- Conversion tools
Download | Description | Name | Size | Download method |
|---|
| Article in PDF format | dm-0501rada.pdf | 460 KB | FTP|HTTP |
About the author | 
| 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. |
Rate this content
| | | |
