Porting to DB2 Universal Database Express Edition Version 8.1 from Microsoft SQL Server 2000

Amyris Rada, DB2 Information Management Software, IBM Toronto Lab, IBM

Team Lead, i2 Partner Integration Center

Summary: This article introduces the IBM ®DB2® Universal Database™ (UDB) Express product and its capabilities, discusses porting databases and applications, and describes the most important aspects of porting applications from Microsoft SQL Server 2000 to DB2 UDB Express.

Tag this!

Date: 01 Aug 2003
Level: Introductory
Activity: 435 views

Overview

DB2 Universal Database Express Edition V8.1 (DB2 UDB Express) is a tailored database offering for the worldwide small and medium business (SMB) market, with focus on enterprises of size 100 to 1000 employees. It combines the power, function, and reliability of an open industry-standards-based relational database with simplicity in packaging, installing, and deploying at a minimal investment cost. DB2 UDB Express meets the data management needs of SMBs positioning themselves for e-business on demand.

This article 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 Express?
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
Read the full article (PDF) here:	ms_sq_to_db2_xp.pdf	404 KB	FTP \|HTTP

Information about download methods Get Adobe® Reader®

About the author

Team Lead, i2 Partner Integration Center

Comments (Undergoing maintenance)

Trademarks | My developerWorks terms and conditions

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/

SITE_ID=1

Zone=Information Management

ArticleID=86829

ArticleTitle=Porting to DB2 Universal Database Express Edition Version 8.1 from Microsoft SQL Server 2000

publish-date=08012003

author1-email=

author1-email-cc=