From: Date: October 27 2005 3:25pm
Subject: Copy Data from MySQL to MS SQL (LinkedServer)
List-Archive: http://lists.mysql.com/win32/17696
Message-Id: <20051027132405.7487.qmail@lists.mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,
We're evaluating MS SQL atm to replace some MS SQL Servers by MySQL and 
so we have much questions to be answered ^^.

In this case we want to write data from our MySQL Server to a MS SQL 
Server. We've a table which we transfer to the MS SQL Server every 5 
minutes. We don't want to have a external tool which handels this.
In MS SQL you can use LinkedServer, which means you specify a 
Server(Connection) in your SqlServer to which you connect and write the 
data.

Greets
Christian Wagner