DB2 Migration from On premise to Cloud

Question

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.

Answer 1

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