![microsoft webmatrix link to mysql database microsoft webmatrix link to mysql database](http://jamshidhashimi.com/wp-content/uploads/2013/10/2-Webmatrix-Database.png)
Having linked the two servers, examples of some things you could do are automatically synchronizing each Update/Insert/Delete on the MS SQL database immediately in the tables on the linked MySQL server or write a SQL query that uses tables and data on both servers simultaneously.
![microsoft webmatrix link to mysql database microsoft webmatrix link to mysql database](https://images-na.ssl-images-amazon.com/images/I/41TNFAtsxsL._SX408_BO1,204,203,200_.jpg)
After linking, the linked MySQL server behaves as if it is a local SQL Server.
Microsoft webmatrix link to mysql database how to#
This document describes how to link a Microsoft SQL Server 7.0/2000 (MS SQL) and a MySQL 4.x server.
![microsoft webmatrix link to mysql database microsoft webmatrix link to mysql database](https://i.stack.imgur.com/Cbj1O.jpg)
Finally, provider options are set on the provider level in the Management Studio under ‘Linked Servers’->’Providers’->’MSDADQL’] Also, Linked Servers are now located under ‘Server Objects’->’Linked Servers’ in the Management Studio. You must now first create an ODBC System DSN that contains all information to connect the MySQL server and then refer to this DSN from the Linked Server dialog when you are creating the linked server. For the newer versions SQL Server 20 most of the article is still applicable, but there is a slight change in the procedure when using the new SQL Server Management Studio. [UPDATE 2010: This article is now over five years old and refers to SQL Server 2000. The document contains an example which uses triggers to automatically propagate any changes to the content of a SQL Server table to a linked MySQL table. This technique can be useful for synchronizing MySQL-driven web pages with data held locally in a Microsoft SQL Server. After linking, tables on both servers can be referenced in one SQL query or stored procedure, with the MySQL database behaving as if it was a local SQL Server database. This document describes how to link a Microsoft SQL Server and a MySQL server by using the ‘linked server’ feature in SQL Server.