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: Data not getting replicated to AWS Redshift

My source DB is AWS RDS and my target table is AWS Redshift. The data is loaded successfully but after that changes are not pushed to the target DB and there are no exceptions. Configuration: Migration type: Full Load, Ongoing Replication Source DB:…
JDev
  • 1,662
  • 4
  • 25
  • 55
0
votes
0 answers

AWS Schema conversion in public schema Pgsql

Using AWS conversion tool I am suppose to MS-SQL conversion into PostgreSQL, Its converting but its creating new schema. I have a public schema and I need to convert into this schema only, Is there any way to select existing schema, by default its…
Md. Parvez Alam
  • 4,326
  • 5
  • 48
  • 108
0
votes
0 answers

Using Amazon S3 as a Source for AWS DMS - Source Endpoint Table structure

I am trying to use S3 as source for importing csv files to Oracle12c RDS with reference to the documentation http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.S3.html. In creating source endpoint there is a section "Table Structure" to be…
Karthick
  • 323
  • 1
  • 3
  • 7
0
votes
0 answers

AWS SCT Postgres RDS to Redshift

I want to create table in Redshift equivalent to the one in Postgres RDS. I am trying to do the schema conversion from Postgres RDS to RedShift RDS. But the SCT (AWS Schema conversion Tool) doesn't provide the interface to map Postgres to Redshift.…
suj
  • 507
  • 1
  • 8
  • 22
0
votes
1 answer

For AWS Data Migration Service, How can we import from S3 bucket to aurora?

Once I have exported an Oracle database to S3, how do I import it on another account, from S3 to Aurora? Does this have to be done manually with lambda, or does DMS service offer an automated way to read from S3 and provide a replica database?
ForeverConfused
  • 1,607
  • 3
  • 26
  • 41
0
votes
3 answers

AWS DMS not giving 100% migaration

HI all we are migrating out database from on premises to Amazon aurora.our database size is around 136GB moreover few tables have over millions of records each. Howover after full load complete out of millions rows approx 200,000 to 300,000 rows…
riya ahuja
  • 260
  • 6
  • 18
0
votes
0 answers

Connect to SQL Server remotely

I am trying to use DMS as source for SQL Server database instance. Used the following image for creating the Windows server: Windows Server 2008 R2 SQL Server 2012 Enterprise on Windows 2008 R2 R2 6.1.7601 From DMS when I connect to SQL Server, I…
shantanuo
  • 31,689
  • 78
  • 245
  • 403
-1
votes
0 answers

AWS DMS RDS PostgreSQL to MYSQL

I am trying to use AWS DMS to migrate our PostgreSQL to MySQL both of which are hosted in AWS RDS. PostgreSQL version = 14.0 MySQL version = 8.0 Below are the steps I followed: created a replication instance created a instance profile. created two…
Saurav Kumar
  • 891
  • 8
  • 14
-1
votes
1 answer

AWS Data Migration Service failing transformation rule for JSON operator

Just getting started with AWS DMS. Having trouble writing a transformation rule using the '->>' operator. I am trying to extract a subcomponent of a json field at source and to add it as a column at destination. Tried using it directly in a…
Kevin G
  • 119
  • 1
  • 8
-1
votes
1 answer

How many hours it will take to transfer 500 gb of data from on premise SQL database to AWS S3 using AWS DMS t4 instance

How many hours it will take to transfer 500 gb of data from on premise SQL database to AWS S3 using AWS DMS. I want to use t3 or t4 instances in AWS DMS
KAUSHIK DEY
  • 19
  • 4
-1
votes
2 answers

I have 6 TB of on premise data. I need to transfer it to AWS S3. What will be the cost of the different approaches

I have 8 TB of on premise data at present. I need to transfer it to AWS S3. Going forward every month 800gb of data will be required to update. What will be the cost of the different approaches? Run a python script in ec2 instance. Use AWS Lambda…
KAUSHIK DEY
  • 19
  • 4
-1
votes
1 answer

Online replication/Mirroring/Migrating Oracle and SQL Server Database to Azure

I am trying to replicate the source database (Oracle 11g and MS SQL Server 201x) to Azure SQL Database. Initially I thought of using Azure DMS(Database Migration Service) to do a full load + Change Data Capture for changes. After started to work on…
java_enthu
  • 2,279
  • 7
  • 44
  • 74
-1
votes
2 answers

AWS DMS Error when trying to replicate Oracle to PostgreSQL

I'm trying to replicate several schemas in a Oracle database to a PostgresSQL database. When the DMS task is started with Full load, ongoing replication type the task fails after sometimes while the tables are in the Before Load status. This is the…
Isuru Pathirana
  • 1,060
  • 1
  • 16
  • 37
-1
votes
1 answer

Reference variables from another Terraform plan

I have created a set-up with main and disaster recovery website architecture in AWS using Terraform. The main website is in region1 and disaster recovery is in region2. This script is created as different plans or different directories. For region1,…
jawad846
  • 683
  • 1
  • 9
  • 21
-3
votes
1 answer

Connecting on-premise to AWS

Can anyone tell the difference between AWS DataSync, database migration service (DMS), storage gateway, direct connect and site-to-site VPN connect? As all these are used to connect with on-premises servers.
AKSHAY GUDELLI
  • 1
  • 2
1 2 3
…
30
31