Stack Overflow
Stack Overflow

Questions tagged [aws-dms]

AWS Database Migration Service (AWS DMS) can migrate your data to and from most widely used commercial and open-source databases such as Oracle, PostgreSQL, Microsoft SQL Server, Amazon Redshift, Amazon Aurora, MariaDB, and MySQL. The service supports homogeneous migrations such as Oracle to Oracle, and also heterogeneous migrations between different database platforms, such as Oracle to MySQL. The source or target database must be on an AWS service.

http://docs.aws.amazon.com/dms/latest/userguide/Welcome.html

465 questions
0
votes
1 answer

AWS DMS service returns different formats of dateTime on target database

I am using AWS DMS to migrate data from RDS mysql (Engine 5.6.34) to dynamoDB. For the first migration, I got datetime data as YYYY-MM-DDTHH:MM:SSZ (source RDS 1) and the second time, i got datetime data as YYYY-MM-DDTHH:MM:SS.SSSSSSZ (source RDS…
Mr Nobody
  • 388
  • 4
  • 11
0
votes
1 answer

AWS DMS Ongoing Replication Falling Behind?

We are using AWS DMS for on-going replication of specific tables from one Oracle RDS database instance to another Oracle RDS database (both 11g). Intermittently, the replication seems to fall behind or get out of sync. There are no errors in the log…
m0r6aN
  • 850
  • 1
  • 11
  • 19
0
votes
1 answer

AWS DMS issues after the migration

I am using AWS DMS for migrating 350G of data. The migration has been completely but the status is showing error. I have checked the cloudwatch logs and got the following errors: E: RetCode: SQL_ERROR SqlState: HY000 NativeError: 1280 Message:…
Arun
  • 21
  • 1
  • 6
0
votes
0 answers

MYSQL dump size variation

I have used AWS DMS for migrating 350 Gb of data. After the migration, I can see that the size of databases in the source and target are not matching, that is there is variation in the size of DBs. I have checked by taking mysqldump and found that…
Arun
  • 21
  • 1
  • 6
0
votes
1 answer

Error While Replicating Database using DMS

I am doing the DMS replication in prod and dev environment both, and my DMS of dev is running fine but getting below error in DMS prod replication. [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: 1461 Message: [MySQL][ODBC 5.3(w)…
Girish
  • 1,717
  • 1
  • 18
  • 30
0
votes
1 answer

Connect to Oracle running on my laptop from AWS DMS

I have been trying to do simple POC for a data migration from oracle db running on my laptop (localhost) to AWS Redshift cluster, using AWS Data Migration Services. I am able to connect to Redshift cluster from AWS SCT, was able to create schemas…
Yuva
  • 2,831
  • 7
  • 36
  • 60
0
votes
1 answer

Security Groups for AWS DMS

I am trying to setup DMS between my on-prem db and cloud. When I try to setup the cloud instance doesn't seem to have necessary privileges to connect to on-prem db. Should I add the security groups in AWS to DMS Replication Instance or Target…
Punter Vicky
  • 15,954
  • 56
  • 188
  • 315
0
votes
2 answers

AWS Schema conversion tool - Connection error

I am trying to migrate my Oracle database to an AWS Redshift cluster, and I am following the steps as documented in the AWS website. When I try to create a project in AWS Schema Conversion Tool, configured for Oracle (running in my laptop), I am…
Yuva
  • 2,831
  • 7
  • 36
  • 60
0
votes
1 answer

DMS - On Going Replication

I am planning to replicate data using DMS between our on-prem db and cloud db. The cloud db will have the data for performing analytics. The DBs are hetrogeneous. Can I do an on-going replication between the on-prem and cloud dbs using DMS? Will the…
Punter Vicky
  • 15,954
  • 56
  • 188
  • 315
0
votes
1 answer

AWS DMS - Scheduled DB Migration

I have Postgresql db in RDS. I need to fetch data from a bunch of tables in postgresql db and push data into a S3 bucket every hour. I only want the delta changes (any new inserts / updates) to be sent in the hourly. Is it possible to do this using…
Punter Vicky
  • 15,954
  • 56
  • 188
  • 315
0
votes
1 answer

Migration on-premise Postgresql into AWS RDS

I work on migration on-premise postgresql 9.5 server into RDS. Basically the chain I have come out look like this: [pg master on-premise] -> [pg slave on-premise] -> [aws dms replication instance] -> [aws rds postgresql] Note that: The replication…
Ming Hsieh
  • 713
  • 2
  • 8
  • 29
0
votes
1 answer

Migration issue while using DMS . Incorrect junk data for empty columns

While migrating from MySQL to ORAcle using AWS DMS servcie, In the source side(MySQL DB instance), some huge column (mediumtext) values are empty for 75% of rows in a table. Whereas in the target (Oracle ), its migrated with some other value (Not…
Siddu Notout
  • 1
0
votes
2 answers

Setting up Ongoing Replication using AWS DMS and RDS

I'm trying to use AWS Database Migration Service (DMS) to setup "ongoing replication" from an AWS RDS hosted SQL Server 2016 database to an EC2 hosted SQL Server 2016 database. When I create a DMS task to do this, I get an…
Muhammad Rehan Saeed
  • 35,627
  • 39
  • 202
  • 311
0
votes
1 answer

AWS DMS Error - SQL Server to MySQL migration

I keep getting this error on AWS DMS, source: SQL Server 2017-12-11T17:03:56 [SOURCE_CAPTURE ]I: Approve full logging setup for all tables has finished (sqlserver_log_utils.c:1916) 2017-12-11T17:03:57 [SOURCE_CAPTURE ]I: Positioning token value…
Pasta
  • 2,491
  • 5
  • 24
  • 33
0
votes
1 answer

Can I connect local sql server database as source in AWS SCT?

I want to connect my local sql server database as source in SCT to convert it to Amazon RDS for MySQL. After Im planning to use DMS for the migration task.
adrianlp05
  • 3
  • 2
1 2 3
…
30
31