Category "aws-dms"

invalid input syntax for type json aws dms postgres

I'm running a task that migrates all data from a postgres 10.4 to a RDS postgres 10.4. Not able to migrate tables which have jsonb column. After error, whole ta

AWS DMS - column adding order

1)when I add a column can i specify its order in the table? A column was adding to the end of table, without this parameter 2) How i can mask data { "rule-

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 a

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 a

includeOpForFullLoad property on Parquet files - AWS DMS

I have tried includeOpForFullLoad property for csv files while reading from oracle and writing in to s3. I wanted to use this property for parquet files. I can

Stop and Resume pglogical Replication -PostgreSQL 12

I wanted to check if there is a way to stop and resume PostgreSQL replication using pglogical? For some reason, if either the publisher or subscriber needs to r

Is there a way to restart an Replication Task in DMS without recreating the task itself?

I'm getting this error when trying to restart my DMS Replication TASK with start_replication_task Boto3 method: An error occurred (InvalidParameterCombinationEx

Restoring database delta between two dumps

We're currently struggling with moving our Aurora Database to an RDS Postgres DB. Our database is quite huge with 80GB and some tables having up to 85 million e