Questions tagged with AWS Database Migration Service
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hello, so the context is:
We have a DMS service that sends data from Oracle to s3, after that a job is run to create the raw stage, and after that raw to trusted. The problem is that they changed...
0
answers
0
votes
61
views
asked 24 days agolg...
I used mysqljump to back up the database, uploaded the sql file to S3 and used Restore from S3 to restore the database, and then failed and reported an error: "Incompatible-restore"
My database...
1
answers
0
votes
138
views
asked 24 days agolg...
When logical replication is enabled in AWS Posgres RDS, and DMS is used to replicate the changes, replication slot gets created for that. DMS replication is only after 4 tables, and in lower...
1
answers
0
votes
426
views
asked 25 days agolg...
Hi,
I can do select * from these but I can't do by field/column.
Is this an expected behaviour?
The database is PostgreSQL and I've setup Oracle to PostgreSQL DMS.
> \dt
...
1
answers
0
votes
164
views
asked a month agolg...
Hello,
We set up AWS DMS, where the source is MS SQL Server 2019, and the target is S3 (with parquet). Setting up CDC copying. And it is important for us to check that DDLs on source work as well:
1)...
0
answers
0
votes
234
views
asked a month agolg...
Greetings,
We have been using only MS-CDC for ongoing replication and had the ECA IgnoreMSReplication turned on.
In order to determine the feasibility of using MS-REPLICATION as an alternative some...
1
answers
0
votes
501
views
asked a month agolg...
When I created a DMS Task in the first instance, I chose Migrate existing data. I now want to change it to do CDC as well.
There doesn't appear to be an option to modify this.
Can anyone confirm...
1
answers
0
votes
248
views
asked a month agolg...
I have a database in Postgress and I use RDS. My database had the standard_conforming_strings property turned off, but I need it to be turned on, I configured it in RDS so that the property is turned...
1
answers
0
votes
670
views
asked a month agolg...
Does DMS support oracle logical standby hosted on EC2 as source for full load and CDC migration to RDS supported target engines. If this is supported configuration, are there any gotchas/limitations...
1
answers
0
votes
345
views
asked a month agolg...
We have a Redshift instance that is being filled via DMS from an Aurora cluster. Because the DMS requires the binlog to process data through to Redshift we have to have it pointing directly to the...
2
answers
0
votes
479
views
asked a month agolg...
Hi,
I am wanting to migrate some tables from Oracle to PostgreSQL. Only 5 out of 50 tables.
I used ora2pg to generate the DDL and created the tables.
I only want to migrate some columns of these 5...
4
answers
0
votes
264
views
asked a month agolg...
When using AWS DMS, all boolean columns in the CDC are consistently marked as `true` (in parquet files that DMS outputs to S3), regardless of their actual value in the source database.
We are using...
0
answers
0
votes
262
views
asked a month agolg...