PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #171
You are planning the migration of a large Oracle database to AlloyDB for PostgreSQL. The database contains a large amount of application logic written as stored procedures that needs to be migrated…
The correct answer is C. Use Database Migration Service. Set up a conversion workspace for schema and code. By using Database Migration Service with a conversion workspace, you get built-in schema and PL/SQL-to-PL/pgSQL code conversion plus a migration job that handles both the one-time backfill and ongoing change-data-capture. That lets you migrate your stored procedures…
Question
You are planning the migration of a large Oracle database to AlloyDB for PostgreSQL. The database contains a large amount of application logic written as stored procedures that needs to be migrated to the target database. You want to minimize both migration effort and downtime for the migration. What should you do-
Options
- AUse Ora2pg for schema and code conversion and data migration.
- BUse Ora2pg for schema and code conversion. Use the extension in AlloyDB and
- CUse Database Migration Service. Set up a conversion workspace for schema and code
- DUse Database Migration Service. Set up a legacy conversion workspace for schema and code
How the community answered
(32 responses)- A9% (3)
- B16% (5)
- C72% (23)
- D3% (1)
Explanation
By using Database Migration Service with a conversion workspace, you get built-in schema and PL/SQL-to-PL/pgSQL code conversion plus a migration job that handles both the one-time backfill and ongoing change-data-capture. That lets you migrate your stored procedures automatically and keep source and target in sync until cut-over, minimizing effort and downtime.
Topics
Community Discussion
No community discussion yet for this question.