MariaDB To SQL Server via Connect Table Type
With rising complexity in applications, organizations are turning to heterogeneous database platforms for scalability, efficiency and cost effectiveness. This leads the database administrators to create connectivity between databases of two different platforms. SQL server has utility of linked server which helps tremendously when it comes to configuring such inter database connectivity. MariaDB based on Linux lacks this feature but surely provides a work around for the same. Here's when table with CONNECT table type comes into picture CONNECT uses this API to access data contained in other DBMS without having to implement a specific application for each one. It works with ODBC drivers provided by Microsoft (freeware), with drivers in place MariaDB can now connect to SQL server using the installed driver with a connection string Microsoft® ODBC Driver 17 for SQL Server® - Windows, Linux create table test_student ENGINE=CONNECT DEFAULT CHARSET=latin1 CONNECTION= 'Driver=/opt/mi...