Back

Explore Courses Blog Tutorials Interview Questions

AWS DMS-Oracle to s3

0 votes
3 views
in AWS by (5.6k points)
I want to migrate my database to AWS using DMS and then I want to migrate in S3 & then using Glue will migrate to Postgres. Can someone suggests to me the procedure to do so?

1 Answer

0 votes
by (12.4k points)

If you are wishing to migrate from Oracle to RDS PostgreSQL then the simplest way would be to use AWS DMS and AWS SCT(Schema Conversion Tool)

While using S3 and Glue is complex and there you need to deal with schema conversion manually and it will make your task more complex. So I would suggest using DMS/SCT it will work great.

You can have a look at DMS, which would help you to work ahead.

Looking forward to master AWS? Check out: AWS Certification

Related questions

Want to get 50% Hike on your Salary?

Learn how we helped 50,000+ professionals like you !

0 votes
1 answer
What is PostgreSQL equivalent of SYSDATE in Oracle?
asked Nov 29, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
how to import data files from s3 to postgresql rds
asked Jul 11, 2019 in AWS by Amyra (12.9k points)
0 votes
1 answer
How to upload a UIImage to S3 with AWS iOS SDK v2?
asked Dec 29, 2020 in AWS by devin (5.6k points)
0 votes
1 answer
How to connect to Amazon AWS S3 with AWS SDK PHP?
asked Dec 16, 2020 in AWS by devin (5.6k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...