The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Multiple servers

Hi,

I'm trying to operate a MariaDB and also use data from SQL Server. Is it possible? Can you direct me to the documentation?

Thank you. Ed

Answer Answered by Federico Razzoli in this comment.

Hi Ed,

Reading and writing to SQL Server form MariaDB is possible using the CONNECT storage engine. CONNECT is designed to see external data as a regular MariaDB table (though the performance obviously cannot be optimal). To connect SQL Serveer, you can create a table of type ODBC. Specific documentation for MariaDB/SQL Server interoperability is work in progress, but I can point you to the CONNECT category and ODBC table type:

The opposite flow is also possible. SQL Server has a feature called Linked Servers. MariaDB can be added as a remote data source via the ODBC protocol.

Cheers, Federico

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.