Microsoft SQL Server to IBM DB2 UDB Conversion Guide

An IBM Redbooks publication

Published 10 June 2005, updated 06 August 2006

cover image

ISBN-10: 0738491195
ISBN-13: 9780738491196
IBM Form #: SG24-6672-00
(552 pages)

More options

Rate and comment

Authors: Whei-Jen Chen, Alain Fisher, Stefan Hummel, Shailendra Kishore, Wei Bin Teah, Ted Wasserman


DB2 Universal Database (DB2 UDB) has long been known for its technology leadership. This IBM Redbooks publication is an informative guide that describes how to convert the database system and applications from Microsoft SQL Server to DB2 UDB Version 8.2.

This guide presents the best practices in conversion strategy and planning, an architecture overview of the two relational database systems, migration tools, and practical conversion examples. It is intended for technical staff involved in a SQL Server to DB2 UDB conversion project.

We discuss, in detail, the conversion of database structure, data, and database objects including stored procedures, triggers, and user defined functions. We address SQL and application conversion considerations. Examples are used throughout the book to illustrate the conversion and to provide solutions and work-arounds for different scenarios.

In addition, we provide a DB2 tools and wizard usage overview, performance considerations, and testing and troubleshooting techniques. Finally, a migration scenario using the IBM DB2 Migration Toolkit is included to show the complete migration process.

Table of contents

Chapter 1. Introduction
Chapter 2. Architecture
Chapter 3. DB2 UDB administration tools
Chapter 4. SQL considerations
Chapter 5. Planning for a conversion
Chapter 6. The IBM DB2 Migration Toolkit for SQL Server
Chapter 7. Database structure conversion
Chapter 8. Data and script migration
Chapter 9. Converting database objects
Chapter 10. Application conversion considerations
Chapter 11. Performing administrative tasks in DB2 UDB
Chapter 12. Post-conversion tuning considerations
Chapter 13. Testing and troubleshooting
Chapter 14. Conversion scenario
Appendix A. Terminology mapping
Appendix B. Data type mapping
Appendix C. Function mapping
Appendix D. Operator mapping
Appendix E. Administrative tasks mapping
Appendix F. SQL limits
Appendix G. Additional material

Follow IBM Redbooks

Follow IBM Redbooks