# Migrating to MariaDB from SQL Server

- [MariaDB Backups Overview for SQL Server Users](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/migrating-to-mariadb/migrating-to-mariadb-from-sql-server.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.