Google Cloud Database Migrations: Heterogeneous

Migrating between fundamentally incompatible database engines—such as moving from commercial legacy systems to cloud-native AlloyDB— is a major architectural shift. Architect this heterogeneous database migration using the DMS conversion workspace and Gemini to refactor database logic and stored procedures. Build reliable, rule-based pipelines with DMS mapping rules and ensure data fidelity via the Data Validation Tool (DVT). Develop the skills to systematically guide an enterprise migration from assessment to production cutover.

Syllabus

Assessment and strategy

Heterogeneous migrations
Business drivers for migration
Dialects and differences
Automated assessment
Module 1 Quiz

Schema and code remediation

AI-assisted remediation
Manual and partner strategy
Application-side remediation
Module 2 Quiz

Transformation pipeline design

Map rule strategies
Type and case transformations
Structural transformations
Object-level filtering
Schema routing and consolidation
Module 3 Quiz

Execution and validation

Connectivity readiness review
Execute the pipeline
Data fidelity with DVT
Analyze DVT reports
Module 4 Quiz

Cutover and optimization

Phased application testing
Final cutover and rollback
Day 2 optimization
Module 5 Quiz
Migrate to AlloyDB for PostgreSQL
Migrate from Cloud SQL for SQL Server to AlloyDB for PostgreSQL using Database Migration Service
Course summary: Heterogeneous migrations