On prem DB2 Migration to PostgreSQL in Azure

Question

Hi,

Does Azure migration service migrate DB2 instance in on prem to PostgreSQL in Azure. How long it will take to migrate Let say we have 1000 tables ?

Or only we have an option of provisioning a VM and running DB2 instance (Rehost strategy) ?

Which is best solution in terms of performance and also cost optimization ?
Thanks,
Venuu

Answer 1

@V R Venuu Maadhav Welcome to Microsoft Q&A Forums and thank your interest in Azure Services.
Currently we support the following migration scenarios

Db2 to

• SQL Server
• Azure SQL Database
• Azure SQL Managed Instance
• SQL Server on Azure VMs

Please check Azure Database Migration Guides for more details.

Unfortunately migrating to Azure Database for PostgreSQL is not supported at this time.

We do have guides for migrating DB2 workloads to Azure Virtual Machines.
Please check the below.

IBM Db2 Azure Virtual Machines DBMS deployment for SAP workload
High availability of IBM Db2 LUW on Azure VMs on SUSE Linux Enterprise Server with Pacemaker
High availability of IBM Db2 LUW on Azure VMs on Red Hat Enterprise Linux Server

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.