Decision Tree — Homogeneous DB Migration to Cloud SQL & AlloyDB with GCP Database Migration…

Decision Tree — Homogeneous DB Migration to Cloud SQL & AlloyDB with GCP Database Migration Service(DMS)

With Google Cloud we love decision trees to simplify our choice of GCP services and approach.

Database Migration service released by GCP in early 2021 has seen tremendous enhancements in supporting database migrations to Cloud SQL and AlloyDB(Postgres). DMS specifically streamlines networking complexity, takes care of initial snapshot of the source database and CDC and monitoring of migration jobs with insights.

In this decision tree approach we are targeting homogeneous DB migrations(same database engine) to GCP with Cloud SQL and Alloy DB(Postgres).

Decsion Tree for Homogeneous DB Migrations

Let's try to analyze the P ostgres database engine as a source. If the source postgres engine is "Yes" as specified in the diamond box i.e. condition is met then you can use DMS. If the condition is "No" then check for other conditions like EDB Postgres DB and seek GCP's expertise to simplify the database migrations.

Hope you enjoyed this blog. Stay tuned for Decision tree approach for Heterogeneous DB Migrations.

*** Known Limitaions of GCP DMS — https://cloud.google.com/database-migration/docs/mysql/known-limitations

---

Decision Tree — Homogeneous DB Migration to Cloud SQL & AlloyDB with GCP Database Migration… was originally published in Google Cloud - Community on Medium, where people are continuing the conversation by highlighting and responding to this story.

Namaste Devops is a one stop solution view, read and learn Devops Articles selected from worlds Top Devops content publishers inclusing AWS, Azure and others. All the credit/appreciations/issues apart from the Clean UI and faster loading time goes to original author.