SQL Server: Set up Linked Server to MySQL

Feb

by Mike Fleming at 7:57 am No Comments MySQL, SQL Server

I saw a post yesterday that explains the simple process of setting up a MySQL database as a linked server in Microsoft SQL Server. SQL Server has had the linked server functionality for years now. In short it allows you to set up a data connection to another RDBMS and grab your data from it. The post below is a great step by step guide to setting up a linked server to a MySQL database.

HOWTO: Setup SQL Server Linked Server to MySQL