Skip to main content

Microsoft SQL Server to IBM DB2 UDB Conversion Guide

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 10 June 2005, updated 06 August 2006

  1. .PDF (6.3 MB)

Share this page:   

ISBN-10: 0738491195
ISBN-13: 9780738491196
IBM Form #: SG24-6672-00

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

    menu icon


    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


    Others who read this also read