Soru

Zorluk: KolayAssess and Select Migration Strategy (7 Rs)

An enterprise is planning to migrate a legacy on-premises web application to AWS. The application currently uses an on-premises Oracle database. To reduce licensing costs, the solutions architect decides to migrate the database to Amazon Aurora PostgreSQL. This change will require converting the schema and rewriting several database queries in the application.

Which migration strategy from the 7 Rs framework is being applied to the database?

  1. A
    Replatforming (Lift-tinker-and-shift)
  2. B
    Rehosting (Lift-and-shift)
  3. Refactoring (Re-architecting)Cevap
  4. D
    Relocating

Cevap

Refactoring (Re-architecting) is the correct migration strategy because migrating from an on-premises Oracle database to Amazon Aurora PostgreSQL requires schema conversion and code refactoring to adapt to the new database engine.
Refactoring (Re-architecting) is correct because converting the database engine from Oracle to Amazon Aurora PostgreSQL is a heterogeneous database migration that requires database schema conversion and application code modifications (e.g., rewriting SQL queries). This is a core characteristic of Refactoring.

Adım Adım Çözüm

1
Identify the source database engine and target database engine.
The source is Oracle (commercial) and the target is Amazon Aurora PostgreSQL (open-source compatible). This is a heterogeneous database migration.
Understanding the nature of the database change helps determine the extent of modification needed.
2
Determine if the application code or schema must change.
Yes, migrating across different database engines requires schema conversion and rewriting SQL queries in the application code.
Changing the database engine breaks direct compatibility, requiring modifications to both the schema and code.
3
Map the required changes to the AWS 7 Rs migration framework.
Since significant modification to the database schema and application code is required to support the new engine, the strategy is classified as Refactoring (Re-architecting).
Refactoring is defined by modifications to the application code or database schema to leverage cloud-native features and platforms.

Anahtar Kavram

Heterogeneous database migrations (e.g., Oracle to Aurora PostgreSQL) require refactoring because they involve schema conversion and application modifications.
Bu soruyu puanla