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.
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
410
views
asked 16 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
158
views
asked 18 days 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
229
views
asked 22 days 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
297
views
asked 25 days 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
237
views
asked 25 days 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
664
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
323
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
472
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
243
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
252
views
asked a month agolg...
IHAC using RDS MSSQL instances, now he is planning to install SQL Reporting Services in its application server running on EC2 (because SRS needs some customizations, cannot activate it using RDS...
1
answers
0
votes
391
views
asked a month agolg...
We have been running with DMS obtaining access to Target Endpoints (RDS SQL Server) via Secrets Manager in all environments for over a year without issue. We have a character exclusion mechanism on...
1
answers
0
votes
230
views
asked a month agolg...