|  | Level: Introductory Amyris Rada, DB2 Information Management Software, IBM Toronto Lab, IBM
01 Aug 2003 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.
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 |
|---|
About the author | | | Team Lead, i2 Partner Integration Center |
Rate this page
| |
|
