Introduction
This blog introduces a custom-built tool designed to migrate database objects from IBM Db2 LUW (Linux, Unix, Windows) to Azure Database for PostgreSQL. While SSMA for Db2 supports migrations to SQL Server, this tool specifically assists with migration to Azure Database for PostgreSQL, helping customers transition smoothly to the Azure ecosystem.
Db2 LUW to Azure database for PostgreSQL
As organizations work to migrate Db2 systems, tools that assist with database migrations are increasingly relevant. The Db2 LUW to Azure PostgreSQL Database Converter is designed to facilitate the migration of IBM Db2 LUW (Linux, Unix, Windows) databases to Azure database for PostgreSQL. Created by the Microsoft Azure SQL CSE/Ninja Team, this tool provides an interface intended to support migration workflows.
With the appropriate drivers and prerequisites, the tool currently supports the conversion of Db2 LUW to Azure database for PostgreSQL. Future versions of this may include enhancements to existing object conversion and support for other Db2 platforms like z/OS and Db2 for i (AS400).
System Requirements
▪ Supports Db2 on LUW version 9.8, 10.1, and later versions
▪ Windows 10, Windows 11
▪ .NET 8.0 Desktop Runtime
▪ Microsoft OLEDB Provider for DB2 is required to access the IBM Db2 Databases.
▪ Azure OpenAI models (For converting Functions and Stored Procedures).
Database Object Conversion
The Db2 LUW to Azure PostgreSQL Database Converter streamlines enterprise-scale database migrations with a segmented workflow. Users are self-guided through connection setup, schema selection and object conversion via intuitive tabs and input fields. With Azure OpenAI integration Db2 LUW functions and procedures are converted seamlessly. The tool also features built-in conversion log and statistics, a robust design for reliable use by engineers and architects during database migrations.
The tool effectively extracts metadata from the source Db2 database and transforms the relevant objects into PostgreSQL formats. All Db2 metadata is retained locally, enabling efficient reuse during subsequent offline conversion process. Error and warning notifications are issued as appropriate, with detailed error log files generated to record any issues arising throughout execution and conversion. Furthermore, a comprehensive telemetry report detailing object conversions is provided upon completion of the process.
Looking to migrate your Db2 LUW workloads to Azure Database for PostgreSQL? Contact the Azure SQL Engineering Team at datasqlninja@microsoft.com to get started with the tool and user guide.
If you have feedback or suggestions for improving this data migration asset, please contact the Database Platform Engineering Team. Thanks for your support!
Note: Db2 editions on z/OS, iSeries, and Linux/UNIX/Windows (LUW) differ in their subsystems, databases, and object definitions/functions. This tool currently supports only Db2 LUW; Db2 z/OS and Db2 iSeries are not yet supported.
Future Road Map: Multiple significant enhancements are scheduled for the current tool, including expanded support for Db2 for z/OS and Db2 for iSeries. Aimed at strengthening compatibility, increasing performance, and introducing additional features to facilitate enterprise-level Db2 database migrations to Azure PostgreSQL.
Microsoft