Microsoft SQL Server to MariaDB Migration

In the modern IT environment, more and more organizations are adopting open source ecosystems.

According to Gartner, by 2018, more than 70% of new in-house applications will be developed on an open-source DBMS and 50% of existing commercial relational DBMS instances will have been converted, or will be in the process of conversion. In the midst of this trend, MariaDB is leading the way as the RDBMS open source solution. MariaDB is the default database for the leading Linux distributions, and it interoperates well with a vast ecosystem of open source solution environments, including Java, Tomcat, OpenStack, and complementary NoSQL solutions, Hadoop and Spark, just to name a few. It is a fait accompli, open source is how serious IT gets done today and MariaDB is the database at the heart of it all. Following this trend, migration from Microsoft SQL Server to MariaDB Enterprise is very popular today because of MariaDB’s feature-rich, highlyperformant and secure database, coupled with simple pricing and robust community innovation. More importantly, open source works best with open source. MariaDB has proven processes, methodologies and conversion tools which can simplify the database migration from SQL Server to MariaDB. This practice will ensure the stored procedures, user-defined functions and triggers written in Transact-SQL to be converted to MariaDB procedural SQL language. This white paper explores the challenges that may arise during migration, and describes best practice migration approaches and solutions.

Download the white paper