Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Google Cloud Database Migrations: Homogeneous

Google via Google Skills

Go to class Write review
Boot.dev Ad

The Most Addictive Python and SQL Courses

Learn More → Simplilearn Ad

Build AI Apps with Azure, Copilot, and Generative AI — Microsoft Certified

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Orchestrate the complete execution of a homogeneous database migration to Google Cloud. In this course, you will see how to use the Database Migration Service (DMS) for live replication and the Data Validation Tool (DVT) to certify data integrity. You will learn the engine specific steps for preparing sources like PostgreSQL and SQL Server for a move to an equivalent managed target such as AlloyDB and Cloud SQL. You will leave ready to oversee a seamless, validated migration, ensuring a fast, reliable, and low risk transition to a managed Google Cloud database.

Syllabus

  • The homogeneous migration framework
    • Introduction to homogeneous migrations
  • Foundations of homogeneous migration
    • Strategic plan to technical execution
    • Configure DMS connectivity and security
    • Prepare the source database
    • Database Migration Service (DMS) architecture
    • Best practice: Infrastructure as Code (IaC)
    • Module 1 Quiz
  • PostgreSQL to AlloyDB
    • Homogeneous modernization
    • Prepare PostgreSQL for logical replication
    • The target: AlloyDB architecture
    • Demo: PostgreSQL to AlloyDB migration
    • Day 2 and AI insights
    • Module 2 Quiz
  • Homogeneous Replatform (SQL Server to Cloud SQL)
    • SQL Server source prerequisites
    • The target: Cloud SQL architecture
    • SQL Server migration workflow
    • Day 2 operations: Cloud SQL Query Store and tuning
    • Module 3 Quiz
  • Post Migration Operations and Synthesis
    • The Data Validation Tool (DVT)
    • The final cutover
    • Day 2: Modernize with IAM and Secret Manager
    • Module 4 Quiz
    • Migrate to Cloud SQL for PostgreSQL
    • Migrate to Cloud SQL for PostgreSQL Using Database Migration Service
    • Congratulations: Course summary
    • Homogeneous Migration Course Summary
  • Your Next Steps
    • Claim credential

Tags

Reviews

Start your review of Google Cloud Database Migrations: Homogeneous

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.