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.
0
votes
1 Answers
0
votes
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.
