Search code examples
mysqlgoogle-cloud-sqldata-migrationdb2-zos

How to migrate DB2 z/OS data to MySQL?

As part of the data migration from DB2 z/OS (Mainframe) to Google cloud SQL, I don't see the direct service/connector provided by google or IBM. So, I am exploring the option to move the data to MySQL first and then to Cloud SQL.

I could see the solution to migrate from Mysql to cloud SQL but not DB2 to MYSQL.

I searched in google for this need but I could not find the resolution.

Will it be connected based on JDBC connection or something else?

Solution

  • The approach of migrating first to CSV and then to Cloud SQL for MySQL sounds good. As you said, you will need to create a Cloud Storage Bucket [1], upload your CSV file to the bucket, and follow the steps here [2] corresponding to MySQL.

    [1] - https://cloud.google.com/storage/docs/creating-buckets

    [2] - https://cloud.google.com/sql/docs/mysql/import-export/import-export-csv#import