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.

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