Microsoft SQL Server to IBM DB2 UDB Conversion Guide
An IBM Redbooks publication
Note: This is publication is now archived. For reference only.
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