# Migrating to MariaDB from SQL Server

- [MariaDB Backups Overview for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-backups-overview-for-sql-server-users.md): Maps SQL Server backup concepts like differential and transaction log backups to MariaDB equivalents such as \`mariadb-backup\` (hot backups) and binary logs for incremental recovery.
- [Understanding MariaDB Architecture](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/understanding-mariadb-architecture.md): An architectural overview for SQL Server DBAs, covering MariaDB's storage engines (InnoDB), transaction logs (undo/redo), buffer pool, and system databases.
- [MariaDB Features Not Available in SQL Server](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-features-not-available-in-sql-server.md): Highlights features unique to MariaDB, such as pluggable storage engines, dynamic columns, and Flashback, which can offer advantages after migration.
- [SQL Server Features Not Available in MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/sql-server-features-not-available-in-mariadb.md): Features available in Microsoft SQL Server that aren't available in MariaDB.
- [SQL Server Features Implemented Differently in MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/sql-server-features-implemented-differently-in-mariadb.md): Differences between features in Microsoft SQL Server and MariaDB.
- [SQL Server and MariaDB Types Comparison](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/sql-server-and-mariadb-types-comparison.md): A reference guide mapping SQL Server data types (e.g., \`money\`, \`bit\`) to their MariaDB equivalents, highlighting differences in precision and storage.
- [Syntax Differences between MariaDB and SQL Server](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/syntax-differences-between-mariadb-and-sql-server.md): Details syntax variations between the two systems, such as string quoting, NULL handling, and DDL statement differences, with advice on using \`sql\_mode='MSSQL'\`.
- [MariaDB Authorization and Permissions for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-authorization-and-permissions-for-sql-server-users.md): Complete MariaDB authorization for SQL Server users: 'user'@'host' accounts, CREATE USER/GRANT syntax, IDENTIFIED VIA plugins, TLS/X509, and role management.
- [MariaDB Replication Overview for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-replication-overview-for-sql-server-users.md): An introduction to MariaDB's asynchronous replication and Galera Cluster for SQL Server users, explaining concepts like binary logs, relay logs, and group commit.
- [MariaDB Transactions and Isolation Levels for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/mariadb-transactions-and-isolation-levels-for-sql-server-users.md): Complete transaction isolation for SQL Server users: START TRANSACTION/COMMIT/ROLLBACK, tx\_isolation levels, WITH CONSISTENT SNAPSHOT, innodb\_lock\_wait\_timeout.
- [Moving Data Between SQL Server and MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/moving-data-between-sql-server-and-mariadb.md): Provides methods for transferring data from SQL Server to MariaDB, including generating CSV files, using \`mariadb-dump\`, or leveraging the CONNECT storage engine with ODBC.
- [Repairing MariaDB Tables for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/repairing-mariadb-tables-for-sql-server-users.md): Explains how to check and repair tables in MariaDB using \`CHECK TABLE\` and \`REPAIR TABLE\`, noting that InnoDB typically handles corruption by crashing to prevent data loss.
- [Setting Up MariaDB for Testing for SQL Server Users](/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server/setting-up-mariadb-for-testing-for-sql-server-users.md): From selecting a MariaDB version to setting it up on Windows, using various packages or Docker, this page covers multiple scenarios.