# AWS/Schreiber Foods - Database Migration Immersion Day

## Agenda

### March 3, 2023
| Start <img width=100/>| End <img width=100/>| Type <img width=100/> | Topic <img width=300/>| Link <img width=80/>|
| -------- | -------- | -------- | -------- |-------- |
| 8:00 AM | 8:15 AM | Welcome | Welcome & Introductions |
| 8:15 AM | 8:45 AM | Presentation | AWS Database Migration Service (DMS) Overview |
| 8:45 AM | 9:15 AM | Presentation | AWS Schema Conversion Tool (SCT) Overview |
| 9:15 AM | 9:30 AM | Lab | Temporary Account Access | [Link](https://catalog.us-east-1.prod.workshops.aws/workshops/77bdff4f-2d9e-4d68-99ba-248ea95b3aca/en-US/envconfig/event-engine) |
| 9:30 AM | 9:45 AM | Break | Break |
| 9:45 AM | 11:00 AM | Lab | Schema Conversion Tool - Oracle to Aurora (PostgreSQL) | [Link](https://catalog.us-east-1.prod.workshops.aws/workshops/77bdff4f-2d9e-4d68-99ba-248ea95b3aca/en-US/oracle-aurora) |
| 11:00 AM | 11:45 AM | Presentation | Database Migration Service (DMS) Overview |
| 11:45 AM | 12:45 PM | Lunch | Lunch |
| 12:45 PM | 2:00 PM | Lab | Database Migration Service (DMS) Overview | [Link](https://catalog.us-east-1.prod.workshops.aws/workshops/77bdff4f-2d9e-4d68-99ba-248ea95b3aca/en-US/oracle-aurora/data-migration) |
| 2:00 PM | 2:30 PM | Lab | Monitoring DMS Migrations |
| 2:30 PM | 2:45 PM | Break | Break |
| 2:45 PM | 3:15 PM | Presentation | Oracle Best Practices | [Link](https://catalog.us-east-1.prod.workshops.aws/workshops/77bdff4f-2d9e-4d68-99ba-248ea95b3aca/en-US/monitoring) |
| 3:15 PM | 3:45 PM | Lab | Troubleshooting Migrations with AWS DMS | [Link](https://catalog.us-east-1.prod.workshops.aws/workshops/77bdff4f-2d9e-4d68-99ba-248ea95b3aca/en-US/troubleshooting) |
| 3:45 PM | 4:00 PM | Ending | Conclusion and Next Steps |

## Temporary Accounts
Use the following link to obtain your temporary AWS account used for today's event.

[Temporary AWS Accounts](https://dashboard.eventengine.run/login?hash=78d4-181b4dd7a4-8d)

## Survey
We appreciate you taking a few minutes to fill out the following survey. Your feedback helps us improve these events.

[Database Migration Immersion Day - Survey](https://survey.immersionday.com/EjgoLEx4R)

## Virtual Room
### Microsoft Teams meeting
Meeting ID: 293 468 431 310
Passcode: FgQ89G

## Related Documentation
[Amazon Web Services Database Migraiton Service](https://aws.amazon.com/dms/)
[AWS - DMS User Guide](https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html)
[AWS - Oracle Database To Amazon Aurora with PostgreSQL Compatibility](https://d1.awsstatic.com/whitepapers/Migration/oracle-database-amazon-aurora-postgresql-migration-playbook-12.4.pdf)
[AWS - Schema Conversion Tool Best Practices](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_BestPractices.html)
[AWS Blog - Debugging Your AWS DMS Migrations: What to Do When Things Go Wrong (Part 1)](https://aws.amazon.com/blogs/database/debugging-your-aws-dms-migrations-what-to-do-when-things-go-wrong-part-1/)