Nieuws/blog

Alle nieuws/blogs met tag: Databases

How-To: MySQL as a linked server in MS SQL Server

Geplaatst door Daniel B. Roy op 12 May 2005

This document describes how to link a Microsoft SQL Server and a MySQL server by using the 'linked server' feature in 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 technique can be useful for synchronizing MySQL-driven web pages with data held locally in a Microsoft SQL Server. 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.