Migrating Application Code to MariaDB Using SQL Mode and MaxScale
In this video, Alejandro Duarte explains the SQL Mode option in MariaDB. This option helps with migrating from databases like Oracle, PostgreSQL, and Microsoft SQL Server to MariaDB. The video also covers SQL transformations with MaxScale filters for high flexibility when performing database migrations.
Related Resources
►Webinar on migrating from Oracle to MariaDB with DBeaver: https://go.mariadb.com/WBN-2024-07-25...
Download MariaDB: https://mariadb.com/downloads/
►Try MariaDB now on Docker: https://hub.docker.com/_/mariadb
Table of Contents
0:00 Intro
0:08 The migration process
1:35 SQL Mode
2:24 Example
3:46 Corner cases
4:29 MaxScale
6:20 Query rewriting filter
8:32 Testing query rewriting
►Follow Alejandro on X/Twitter: / alejandro_du
►Follow MariaDB on X/Twitter: / mariadb
►Subscribe to the MariaDB channel:
/ mariadb
►Explore MariaDB Products: https://mariadb.com/products
►Check out the MariaDB DeveloperHub: https://mariadb.com/developers/
►Get in touch with MariaDB experts via Slack: https://mariadb-community.slack.com/ (invite: https://r.mariadb.com/join-community-...)
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 #oracle #postgresql #sqlserver #mysql #maxscale #dbeaver #migration #databases