Query an MS-SQL server from MySQL server
mysql, sql-server
Solution
As far as I'm aware, you can't query any other RDBMS vendor from MySQL. MySQL's remote access feature is `FEDERATED` tables, which only work with other MySQL databases as far as I know.
About the simplest way you could do this would be to use SQL Server's Import/Export Wizard to create a simple package that copies the data to your MySQL server through an ODBC or ADO.NET connection to the MySQL database.
Problem
I work for a large organization that has an established 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... -Directly query our MS-SQL server from my MySQL server and/or -Set up some sort of job that will copy data systematically from the MS-SQL server to our MySQL server. It looks like Linked Servers may be part of the solution, however everything I have found describes scenarios where MS-SQL is accessing MySQL, not the other way around. To be clear I want my MySQL server to talk to/query/pull data from my MS-SQL server. Any help appreciated!