DB2 Migration from On premise to Cloud

Boopathy, Elango 106 Reputation points


Do Azure currently support running DB2 instance in Azure cloud Database ? If not, can we migrate using Azure Database migration services from DB2 to Azure Mysql or PostgreSQL etc. How long it will take to migrate ....let say we have 1700 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 ?

Elango Boopathy.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
507 questions
Azure Database for PostgreSQL
0 comments No comments
{count} votes

Accepted answer
  1. Navtej Singh Saini 4,176 Reputation points


    There is no direct path to move DB2 to Azure PaaS service like Azure DB for MySQL or Postgresql except Azure SQL SB. Here is the documentation for the same.


    Other two ways to move your DB to cloud is:

    As you mentioned to move the DB2 to a VM in Azure Cloud.

    Move DB2 to MySQL or Postgresql while the Db is on premises and then move the Db to corresponding PaaS service e.g. Azure DB for MySQL or Postgresql.

    Second method will ensure proper testing on premises for your Db workload and proper migration.

    Hope this helps.


    Navtej S

    0 comments No comments

0 additional answers

Sort by: Most helpful