We're experiencing issues when using Amazon DMS for ongoing replication of a MySQL/MariaDB database. The issue specifically happens with TIME columns, whose values get garbled like this: 13:22:31 becomes 112:16:02 13:23:59 becomes -911:43:62 (which is actually below the documented minimum…
I am trying to create a DMS replication task using Terraform. The credentials for the endpoint are correct. When I start the replication task, it Fails but the cloudwatch logs aren't that helpful. This is what I see: .... 2024-05-24T07:42:20.000Z…
I have two identical databases, with two identical tables. The source database's table has data and the target database's table has no data. The tables in both databases are named testt. What the data looks like now in the source…
I'm running some tests of transform rules for the AWS Database Migration Service (DMS). The source database is MongoDB (I'm using AWS DocumentDB) and the target database is PostgreSQL (I'm using AWS RDS). I'm using "document mode" (as opposed to…
I had a quick question regarding Amazon DMS transformation capabilities. So basically, I have a source database (MySQL) that I need to migrate to destination database (Aurora). During this migration we have a Primary Key called id that needs to…
I'm trying to replicate data from MongoDB Atlas into an S3 data lake (not mongo's data lake) using AWS Data Migration Services, but I'm getting this error: Failed to establish a connection to MongoDB using the following parameters: 'mongodb://mongodb+srv://[theUsername]:[thePassword]@[theServer].mongodb.net:27017/?retryWrites=false' I'm…