Key points & Best practices to consider while migrating from Oracle in house Database to mysql Cloud database

Question

Can some one suggest Key points & Best practices to consider while migrating from Oracle in house Database to mysql Cloud database. 
 
 Basically i need to list the check points for migration of on premise environment to cloud environment specifically for database where it needs to be move to mysql from oracle. 
 
 Thanks

Manuel Otero · Answer

Integration what Miles mentioned before, the Appian playbook provides some considerations regarding data migration 
 - on-premise vs cloud database options: https://community.appian.com/w/the-appian-playbook/2741/customer-managed-vs-cloud-managed-database 
 - if you need to prepare migration scripts that can be rerun: https://community.appian.com/w/the-appian-playbook/1560/sql-scripts-that-can-be-rerun 
 - if you need to re-create equivalent to oracle materialized views: https://community.appian.com/w/the-appian-playbook/2270/materializing-mysql-views 
 Considering that Appian in the meantime migrated from MySql to MariaDB here's a nice whitepaper from Maria DB to look at for database considerations (after the initial sales comparison, goes into more technical stuff): https://mariadb.com/wp-content/uploads/2020/02/migrate-to-mariadb-from-oracle_whitepaper_1059.pdf?aliId=eyJpIjoiSll1K3JYSHE2SlNqZU43TCIsInQiOiJJUkIyeU1acWs3UlVLVkxIaXVjakp3PT0ifQ%253D%253D