QuestionQ5

VerifiedMigrate data solutions

You are planning to migrate a large Oracle database to AlloyDB for PostgreSQL. The database contains a substantial amount of application logic in stored procedures that must be migrated to the target database. You want to minimize both the migration effort and migration downtime. What should you do?

Explanation

Database Migration Service conversion workspaces convert Oracle schema and supported code objects, including stored procedures, to PostgreSQL syntax. A continuous Database Migration Service job performs the initial data backfill and then uses change data capture (CDC) to keep AlloyDB synchronized until cutover, which reduces downtime. Legacy conversion workspaces are older, more limited, use Ora2Pg-based conversion, and are not recommended for migrations.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!