 | Level: Introductory Amyris Rada (arada@ca.ibm.com), DB2 Information Management Software, IBM Toronto Lab
17 Jul 2003
Updated 11 Jul 2005 This article introduces IBM® DB2® UDB™ products and their capabilities, discusses porting databases and applications, and describes the most important aspects of porting applications from Sybase Adaptive Server Enterprise 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.
This article introduces IBM DB2 Universal Database (UDB) products and their capabilities, discusses porting databases and applications, and describes the most important aspects of porting applications from Sybase Adaptive Server Enterprise 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 should you port to DB2 UDB?
- Information on the DB2 UDB product family
- Sybase data types conversion to DB2 UDB
- Administration issues
- Implementation differences
- Programming interfaces
- DB2 CLI vs. ODBC functions
- Information on conversion tools
Download | Description | Name | Size | Download method |
|---|
| Article in PDF format | sybase_to_db2_v8.pdf | 522 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
| | | |
