Tips and Tricks for Migrating from Oracle to MariaDB

When migrating applications from Oracle to MariaDB, using the MariaDB SQL_MODE=Oracle feature is really helpful. Many Oracle data types can now be used with MariaDB, PL/SQL and several Oracle-specific syntax constructs. Despite this high degree of compatibility, some items are not supported and need additional work. This session offers advice on how to smoothly migrate a database application from Oracle to MariaDB.
►Slides: https://mariadb.com/wp-content/uploads/2023/05/OpenWorks-2023-Tips-and-Tricks-for-Migrating-from-Oracle-to-MariaDB-Anders-Karlsson.pdf
►Try MariaDB with Docker: https://mariadb.me/45SZFo7

Table of Contents
0:39 Agenda
2:27 Intro to migration
5:30 High level Differences
9:59 SQL_MODE=ORACLE?
12:10 Schema migration
22:14 Conclusion

►Follow MariaDB on Twitter: https://twitter.com/mariadb
►Subscribe to the MariaDB channel:
https://www.youtube.com/mariadb
►Explore MariaDB: https://mariadb.com
►Learn about SkySQL: https://mariadb.com/products/skysql
►Check out the MariaDB DeveloperHub: https://mariadb.com/developers/
►Get in touch with MariaDB experts via Slack: https://mariadb-community.slack.com/

MariaDB is making a big impact on the world. Whether you’re checking your bank account, buying a coffee, shopping online, making a phone call, listening to music, taking out a loan, or ordering takeout–MariaDB is the backbone of applications used every day. Companies small and large, including 75% of the Fortune 500 run MariaDB, touching the lives of billions of people. With massive reach through Linux distributions, enterprise deployments, and public clouds, MariaDB is uniquely positioned as the leading database for modern application development.

#MariaDB #Database #Data #SQL