Copy Data from MySQL to MS SQL (LinkedServer)

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

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Copy Data from MySQL to MS SQL (LinkedServer)

--=_alternative 0048E1F7852570A8_=
Content-Type: text/plain; charset="US-ASCII"

If I understood your question, you can automate data transfers between MS
SQL Server and MySQL several ways. Here is a simple outline of one way
that could work:
A) Create linked tables pointing from from MS SQL to MySQL
B) Construct a DTS package in MS SQL that uses the linked tables as the
data source or data destination as appropriate
C) Use the job scheduler (or any external scheduler) to execute your DTS
package on a regular basis.

MySQL does not support "linked tables" to any other database system except
MySQL (so far). The FEDERATED database engine is in its initial release
(with v5.0) and as soon as they work out the kinks with FEDERATE-ing with
ODBC data sources then you will be able to construct a MySQL-based SQL
script to do what you want from within the MySQL server. You can automate
the script with any scheduling utility you have at hand (CRON, AT, ,,,)

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine



Christian Wagner wrote on 10/27/2005 09:25:23
AM:

> 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
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=sgreen@unimin.com
>

--=_alternative 0048E1F7852570A8_=--