MS-SQL server query from MySQL server

Question

I work in a large organization that has an installed and well-populated MS-SQL server. However, I am not a Microsoft user, and my database of choice is MySQL. I am looking for a solution that will allow me to either ...

-Just request our MS-SQL server from my MySQL server

and / or

-Set some task that will systematically copy data from the MS-SQL server to our MySQL server.

It seems that Linked Servers may be part of the solution, however, everything I found describes scenarios in which MS-SQL accesses MySQL, and not vice versa.

To be clear, I want my MySQL server to speak with / query / pull data from my MS-SQL server.

Any help appreciated!

Answer 1

As far as I know, you cannot query any other DBMS provider from MySQL. The MySQL remote access feature is FEDERATEDtables that, as I know, only work with other MySQL databases.

The easiest way to do this is to use the SQL Server Import / Export Wizard to create a simple package that copies data to your MySQL server through an ODBC or ADO.NET connection to the MySQL database.

Answer 2

To be clear, I want my MySQL server to talk to / query / pull data from my MS-SQL server.

, , . , / "", " ms-sql" ad-hoc ETL. , .

MS-SQL , () (b) POSIX. MS-SQL - , Windows. , MS-SQL Ruby C TinyTDS ActiveRecord.

, mainting , C , Sequel, , - ETL ActiveRecord - , , TinyTDS.