The information on the AWS Aurora and DataMigration info from Oracle is shared in the linked in vlog: LinkedIn | YouTube | Krishna Sarabu | Joseph DiCaro
There are several blogs supplied by AWS for self-migration and many vendors listed by AWS who can help in the migration of the database.
A few notes are mentioned below:
- Scalability
- Amazon DMS- Data Migration Service
- AWS- Schema Conversion tool – Assessment report in csv – helps to create reports
- Oracle to AWS Aurora database migration support.
- DMS Trouble shooting blogs!
Best Practices:
- Table spaces
- Index Types: Hash, B-Tree, GIN, GiST, BRIN, SP-GiST, partial, expression
- Data types: 64 base types
- Dual Table – Do not mock dual table- use view if necessary
- Nulls- PostgreSQL and Oracle use nulls differently
- Sequences – in PostgreSQL- each session has its own cache
- Exceptions
- Design guidelines