question

BoopathyElango-7282 avatar image
0 Votes"
BoopathyElango-7282 asked azure-cxp-api edited

DB2 Migration from On premise to Cloud

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-mysqlazure-database-postgresql
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered

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


5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.