Porting to DB2 Universal Database V8 from Microsoft SQL Server 2000

Level: Introductory

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

01 Mar 2003
Updated 11 Jul 2005

	Get the download

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

Download

Description	Name	Size	Download method
Article in PDF format	0303rada.pdf	525 KB	FTP|HTTP

	Information about download methods			Get Adobe® Reader®

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

Please take a moment to complete this form to help us better serve you. Did the information help you to achieve your goal? Yes No Don't know   Please provide us with comments to help improve this page:   How useful is the information? 1 2 3 4 5 Not useful Extremely useful

Back to top