'AWS DMS Source Schema Change

There's a DMS task that is picking data from oracle DB and target is S3 parquet. DMS CDC is in replication ongoing state.

I have a requirement where I need to add a column in one of source tables in Oracle, which already has 5 columns. This table is a part of ongoing replication of DMS CDC. Before doing any changes, I want to understand how DMS will handle this. Any help will be appreciated.

Also, if target was some other database (for ex: PostgreSQL RDS), what will happen in that case?

database-schemaaws-dms


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Terraform update Route53 DOMAIN NameServers

Terraform update Route53 DOMAIN NameServers

Terraform update Route53 DOMAIN NameServers

Amazon AWS S3 to Force Download Mp3 File instead of Stream It

How to enable terraform module only with a specific workspace

AWS RDS Postgres: WAL_LEVEL not set to 'logical' after changing rds.logical_replication = 1

Use terraform to set up a lambda function triggered by a scheduled event source

Use terraform to set up a lambda function triggered by a scheduled event source

Self stopping EC2 once task complete?

AWS - SWF - Asynchronous method

Why my cloudformation template is over 1 MB?

AWS elastic beanstalk - WARN install EACCES: permission denied, access '/tmp/.npm'

Aws step functions - Resume from failed step function activity instead of starting a new execution

Redirect Elastic Beanstalk URL to domain name

node-lambda - TypeError: handler is not a function