CODEWITHSUNDEEP
amazon-web-servicesaws-dms
ForeverConfused
ForeverConfused

Reputation: 1767

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?

Upvotes: 0

Views: 474

Answers (1)

E.J. Brennan
E.J. Brennan

Reputation: 46849

Amazon Data Migration Service doesn't have S3 files as a valid option for a data source. It is intended to be used to migrate a live database from one running database server to another:

On-premises and Amazon EC2 instance databases

  • Oracle versions 10.2 and later, 11g, and 12c, for the Enterprise, Standard, Standard One, and Standard Two editions
  • Microsoft SQL Server versions 2005, 2008, 2008R2, 2012, and 2014, for the Enterprise, Standard, Workgroup, and Developer editions. The Web and Express editions are not supported.
  • MySQL versions 5.5, 5.6, and 5.7 MariaDB (supported as a MySQL-compatible data source)
  • PostgreSQL 9.3 and later
  • SAP Adaptive Server Enterprise (ASE) 15.7 and later

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

Upvotes: 1

Related Questions