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 <christian.wagner@stripped> 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=1
>
