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.
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
...
0
answers
0
votes
19
views
asked 7 hours 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
100
views
asked 4 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
122
views
asked 7 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
117
views
asked 8 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
225
views
asked 8 days 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
206
views
asked 11 days 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
338
views
asked 11 days 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
113
views
asked 11 days 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
153
views
asked 17 days 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
244
views
asked 18 days 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...
0
answers
0
votes
143
views
asked 19 days agolg...
I'm doing a test migration (Oracle to Postgres) of a single table (9K rows, 0.01GB, has 1 BLOB field) to prove that it works.
But it becomes stuck without further events for 1h+ .
Replication type:...
2
answers
0
votes
155
views
asked 20 days agolg...