The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Porting to DB2 Universal Database V8 from Microsoft SQL Server 2000

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

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.

Summary: 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.

Date: 11 Jul 2005 (Published 01 Mar 2003)
Level: Introductory

Activity: 2340 views
Comments:

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: