Hi what are the steps needed to migrate my database(Oracle) to AWS using DMS. i want to migrate in S3 and then using glue i will migrate it into postgres. can anyone suggest step by step process or some link or video which can help. thanks in advance.
Asked
Active
Viewed 210 times
1 Answers
0
If you want to migrate from Oracle to RDS PostgreSQL the most simple way is to use AWS DMS (Data Migration Services) and the AWS Schema Conversion Tool (AWS SCT).
I will suggest you to take a look at DMS, it will simplify your tasks.
Using S3 and Glue is a lot more complex, you will need to deal with the schema conversion manually, with the datatypes, the loading and so on; that is not the way to handle this task.
I used DMS/SCT several times with great success.
Gerardo Arroyo
- 151
- 5
-
True, i think even the Stored Procedures can be migrated as well. – Yuva May 29 '20 at 06:07
-
Thanks Gerardo can you suggest me steps or any links or videos how to migrate on premise Oracle data to RDS PostgeSQL. – ANJAN TANEJA Jun 06 '20 at 10:49
-
Yes, you can use this link from [AWS](https://docs.aws.amazon.com/dms/latest/sbs/CHAP_RDSOracle2PostgreSQL.html). Best regards – Gerardo Arroyo Jun 08 '20 at 21:16