Share via

OLD DB2 zm/vm migrate Azure Sql managed instance

marjanBanoo-1193 31 Reputation points
2022-10-04T19:34:29.907+00:00

I do have an old db2 which has ZM/VM 6.4 and want to migrate to Azure. apparently SSMA doesn't support this. and Also client doesnt want to upgrade Db2
what are another option I can migrate this db to azure sql mi ?

Azure SQL Database
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
Answer accepted by question author
  1. Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator
    2022-10-07T13:21:26.663+00:00

    Marjan,

    Since the version of the DB2 server is too old to be supported by SQL Server Migration Assistant and other tools like Azure Data Factory, plus the organization is not considering to upgrade that version of the DB2 server, then the solution I will propose to you is to export the data as text delimited format or CSV, upload it to an Azure Storage Account, then import that data to Azure SQL Managed instance using tools like bcp, Azure Data Factory Copy Data Tool, or use External Tables.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. marjanBanoo-1193 31 Reputation points
    2022-10-07T13:25:17.493+00:00

    Thank you for the solution. definitely we should use text and azure storage.

    1 person found this answer helpful.

Your answer

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