Converting database objects from Db2 to Azure Database for PostgreSQL

Introduction

Database migrations are complex and requires considerable knowledge of both source and target databases. In general, these migrations involve understanding differences between the database systems and ensuring a smooth database object conversions and data migrations.

For customers migrating from Db2 to Azure database for PostgreSQL, we have built a custom tool that can convert database objects from Db2 to Azure Database for PostgreSQL. If the target database is Azure SQL (or SQL Server on-premises), Microsoft provides SSMA for Db2 tooling that does both object conversion and data migration.

System Requirements

• Windows 10, Windows 11
  
• Microsoft .NET Framework 4.6
  
• Microsoft OLEDB Provider for DB2 is required to access the IBM Db2 Databases.
  

Converting Database Objects

This tool is a console application that runs on Windows. The source and target connection strings are required to initiate the object conversion. After successful connection, the tool extracts the source Db2 metadata and converts the database objects to PostgreSQL objects. The metadata from Db2 is stored locally, which enables reusability for future offline conversions. The tool outputs errors and warnings as well and creates error log files for any execution and conversion errors. A final telemetry report with object conversion summary is also provided.

Please reach out to us datasqlninja@microsoft.com for the custom tooling and the User’s Guide.

NOTE: This custom tool currently supports Db2 LUW only. Db2 z/OS and Db2 i Series (i.e. AS400) are not yet supported.

Feedback

If you have feedback or suggestions for improving this data migration asset, please contact the Azure Databases SQL Customer Success Engineering Team. Thanks for your support!

Continue reading...