Mactores DB assessment guides you through migrating a database from Oracle Database system to PostgreSQL, including evaluation and planning.

Deliverables include

1. Analysis of the existing database architecture, including the type of database, version, and hardware in the current environment.
2. Determination of the desired target environment, including the type of database and version.
3. Evaluation of data compatibility between the current and target environments, including checks for data types, functions, and stored procedures.
4. Analysis of the schema of the current database and determination of necessary changes for migration to the target environment.
5. Planning for data migration, including use of migration tools such as AWS DMS, custom scripts, and data migration verification.
6. Assessment of application compatibility, including estimation of code changes and effort required with Automated Mactores tools.
7. Identification of necessary performance optimizations for the target environment.
8. Planning for monitoring the performance of the new database.
9. Testing in a staging environment and preparation of a go-live plan.
10. Identify potential risks and develop a mitigation plan in case of issues.