DB2 Migration from On premise to Cloud

Boopathy, Elango 106 Reputation points
2020-05-26T11:06:06.167+00:00

Hi,

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 ?

Thanks,
Elango Boopathy.

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

Accepted answer
  1. Navtej Singh Saini 4,226 Reputation points Microsoft Employee
    2020-05-28T03:31:25.537+00:00

    Hi

    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.

    DB2toAzureSQLDB

    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.

    Thanks

    Navtej S

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.