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
Discussion posts and replies are publicly visible
One area to investigate would be if your application uses any SQL that would be specific to Oracle. If it is generic interaction via Appian design patterns, likely straight forward. If it is custom SQL specific to Oracle or plug-ins that use PL/SQL, those would need to be re-written.
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