Examkin

Soru

Zorluk: ZorDatabase Migration and Schema Conversion using DMS and SCT

A company is planning to migrate a highly active on-premises Microsoft SQL Server database to an Amazon Aurora PostgreSQL-Compatible Edition DB cluster. The migration must convert all SQL Server database schemas, stored procedures, and triggers, and must be executed with minimal downtime. The database contains several tables with frequent update activities. A Solutions Architect is designing the migration process using the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) with Change Data Capture (CDC). Which strategy should the Solutions Architect recommend to perform this migration successfully?

  1. A
    Use AWS SCT to convert the SQL Server schema and stored procedures to PostgreSQL, and apply the schema to the target Aurora PostgreSQL DB cluster. Create an AWS DMS task configured for Full Load plus CDC, using the default source endpoint configurations without enabling MS-Replication or Change Data Capture (CDC) on the SQL Server instance.
  2. Use AWS SCT to convert the database schema, stored procedures, and triggers, and apply the converted schema to the target Aurora PostgreSQL DB cluster. Configure the source SQL Server database to use the Full Recovery model, perform a full backup, enable MS-Replication or Change Data Capture (CDC) on the source database, and configure the AWS DMS task to perform a Full Load and continuous Change Data Capture (CDC).Cevap
  3. C
    Replatform the database by using SQL Server Native Backup and Restore to copy the backup files directly to Amazon S3, and restore them into Amazon RDS for SQL Server. Use AWS SCT on the restored database to convert the schema and stored procedures, and directly migrate the database code and tables to Aurora PostgreSQL.
  4. D
    Use AWS SCT to convert the SQL Server schema and apply the schema directly to the Aurora PostgreSQL primary instance. Configure AWS DMS to run a Full Load task targeting the Aurora Read Replica, then enable Aurora Replica Auto Scaling to handle continuous replication workloads from the source SQL Server database.

Cevap

The correct strategy requires converting the schema and database code from SQL Server to PostgreSQL using the AWS Schema Conversion Tool (AWS SCT) and applying it to the target Aurora PostgreSQL DB cluster. For the ongoing data replication (CDC) via AWS DMS, the source SQL Server database must be configured with the Full Recovery model, a full backup must be taken to initiate the log sequence chain, and MS-Replication or MS-CDC must be enabled to allow DMS to read the database transaction logs.
The correct strategy requires converting the schema and database code from SQL Server to PostgreSQL using the AWS Schema Conversion Tool (AWS SCT) and applying it to the target Aurora PostgreSQL DB cluster. For the ongoing data replication (CDC) via AWS DMS, the source SQL Server database must be configured with the Full Recovery model, a full backup must be taken to initiate the log sequence chain, and MS-Replication or MS-CDC must be enabled to allow DMS to read the database transaction logs.

Adım Adım Çözüm

1
Run AWS SCT to convert SQL Server schemas, stored procedures, and triggers, and apply the generated PostgreSQL DDL schemas to the target Amazon Aurora PostgreSQL cluster.
The target Aurora PostgreSQL database is initialized with the converted tables, procedures, and triggers.
This is a heterogeneous migration, so schema conversion must occur before copying the actual data.
2
Ensure the source SQL Server database uses the Full Recovery model, perform a full backup of the source, and enable either MS-Replication or MS-CDC on the tables being migrated.
The SQL Server database is ready to record and maintain transaction logs in a format that AWS DMS can read for ongoing changes.
AWS DMS requires these configuration parameters to access the SQL Server transaction log replication capabilities for CDC.
3
Create and run an AWS DMS replication task using the 'Full Load + CDC' migration type targeting the Aurora PostgreSQL primary DB instance.
Data is successfully loaded, and updates are replicated to the target with minimal downtime.
The combination of Full Load and CDC allows migration of historical data followed by continuous updates, keeping the target database in sync until cutover.

Anahtar Kavram

Heterogeneous database migration from Microsoft SQL Server to Amazon Aurora PostgreSQL requires schema conversion via AWS SCT and CDC prerequisites on the source SQL Server database (Full Recovery model, backups, and MS-Replication/MS-CDC) to enable continuous replication via AWS DMS.
Bu soruyu puanla

Konular

Database Migration and Schema Conversion using DMS and SCT

Bu konudan daha fazla soru