Query an MS-SQL server from MySQL server

Question

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!

what about Microsoft® SQL Server® ODBC Driver 1.0 for Linux microsoft.com/en-us/download/details.aspx?id=28160 I see alot about how to configure it...but now how to actually use it to query the MS-SQL server. — Mark Locklear
– Mark Locklear, Commented Apr 24, 2014 at 13:34
This dude seems to have alot of good info on the topic zxtech.wordpress.com — Mark Locklear
– Mark Locklear, Commented Apr 24, 2014 at 13:45
Very good how to here: blog.afoolishmanifesto.com/posts/… Going to give this a shot and will post as an answer if I can get it to work. — Mark Locklear
– Mark Locklear, Commented Apr 24, 2014 at 13:50

Bacon Bits · Accepted Answer · 2014-04-23 14:40:31Z

2

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.

answered Apr 23, 2014 at 14:40

Bacon Bits

32.5k6 gold badges63 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MetaSkills · Accepted Answer · 2014-04-23 14:39:13Z

1

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

I think it is hard to even assume this is the best decision. Without a TON more context of what the real problem is and/or the real "need", answers vary widely from "just use ms-sql" to other levels of ad-hoc ETL. That said, some abstract feedback.

There is nothing wrong with MS-SQL, as long as you are (a) not paying for it and (b) have a clean solution to use it from a real POSIX based system. Technically, MS-SQL is a great database, I just dislike Windows. To that end, I made sure that working with MS-SQL from Ruby was done well at both the C extension layer with TinyTDS and the ActiveRecord adapter.

Sadly, I have personally stopped maintaing the later, but the C extensions are strong and even used by great projects like Sequel which if you had to some sort of raw ETL without the overhead of ActiveRecord is a great choice since it has adapter for all DBs, TinyTDS included.

answered Apr 23, 2014 at 14:39

MetaSkills

1,85418 silver badges15 bronze badges

1 Comment

Mark Locklear Over a year ago

Thanks for taking time to comment Ken!

Collectives™ on Stack Overflow

Query an MS-SQL server from MySQL server

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related