Skip to main content


developerWorks  >  Information Management  >

Porting to DB2, Version 8.1 from Sybase Adaptive Server Enterprise

developerWorks

Level: Introductory

Amyris Rada (arada@ca.ibm.com), DB2 Information Management Software, IBM

17 Jul 2003
Updated 11 Jul 2005

Get the download

This article introduces IBM® DB2® 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 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 you should port to DB2
  • Information on the DB2 product family
  • Sybase data types conversion to DB2
  • Administration issues
  • Implementation differences
  • Programming interfaces
  • DB2 CLI versus ODBC functions
  • Information on conversion tools


Download

DescriptionNameSizeDownload method
Article in PDF formatsybase_to_db2_v8.pdf522 KBHTTP
Information about download methodsGet Adobe® Reader®


About the author

Amyris Arada

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


Please take a moment to complete this form to help us better serve you.



 


 


Not
useful
Extremely
useful
 


Back to top


Document options

Document options requiring JavaScript are not displayed


My developerWorks needs you!

Connect to your technical community


Rate this content

Help us improve this content