PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #181
Your company is migrating a legacy on-premises Oracle database to Cloud SQL for PostgreSQL. As a part of the migration, you need to convert schema and other database code objects, such as procedures,
The correct answer is D. Use Database Migration Service code conversion workspace, then review and refactor as needed.. Use Database Migration Service’s conversion workspace to auto-convert your Oracle schema and PL/SQL code into PostgreSQL DDL and PL/pgSQL. Then simply review and refactor any edge cases - this approach minimizes manual rewrites and keeps application changes to a
Question
Your company is migrating a legacy on-premises Oracle database to Cloud SQL for PostgreSQL. As a part of the migration, you need to convert schema and other database code objects, such as procedures, functions, and triggers, from Oracle to PostgreSQL. The database migration needs to be accomplished with minimal application code changes and manual intervention. What is the Google-recommended approach you should do-
Options
- AManually rewrite both the Oracle schema and queries to be compatible with PostgreSQL syntax
- BUse a schema conversion tool to automatically convert the Oracle schema to PostgreSQL
- CMigrate the data directly from Oracle to PostgreSQL without any conversion. Rely on application-
- DUse Database Migration Service code conversion workspace, then review and refactor as needed.
How the community answered
(19 responses)- A11% (2)
- B5% (1)
- D84% (16)
Explanation
Use Database Migration Service’s conversion workspace to auto-convert your Oracle schema and PL/SQL code into PostgreSQL DDL and PL/pgSQL. Then simply review and refactor any edge cases - this approach minimizes manual rewrites and keeps application changes to a
Topics
Community Discussion
No community discussion yet for this question.