All geek questions in one place

Connect to Sql Server from MySQL

How to connect to SQL Server database from MySQL server? I need to use MySQL as a proxy database (query for all SQL servers and MySQL related to it).

I need the type of function "linked server" on the SQL server.

+3
source share
1 answer

You cannot - the closest MySQL has the FEDERATED engine, but it only supports connecting to other instances of MySQL and not to another database provider.

Only SQL Server Linked Server and Oracle Database Link technology support connecting to other database providers (what I know), so you have to use SQL Server as a proxy for MySQL, and not vice versa.

+2

Source: https://habr.com/ru/post/1771099/

More articles:


All Articles