Hello group,

i am relatively new to SQL-Server database, but i have lots of
experience with DB2 and Oracle Database. One of my tasks is setting up
a replication between a Mysql-Database running on Linux and one of our
SQL-Servers.

How do i achieve this ?

If i understand the documentation correctly you have to program the
replication mechanism for yourself or you have to use some third party
tool.

Could anyone please outline, how to set up the replication mechanism
(pointing me to some web-site should be enough) and also tell me if
there is any third party tool.

Thanks in advance and greetings from Vienna

Uli

See "Replication and Heterogeneous Data Sources" in the SQL books online.

MySQL to SQL Server - you can use an ODBC or OLE-DB driver for full
transactional replication.
SQL Server to MySQL - it looks like you can only grab snapshots.

Replication within MySQL looks likes its only between MySQL instances.

"Uli" <uli2003wien@lycos.at> wrote in message
news:7643a3d9.0412160038.20abef84@posting.google.c om...
> Hello group,
>
> i am relatively new to SQL-Server database, but i have lots of
> experience with DB2 and Oracle Database. One of my tasks is setting up
> a replication between a Mysql-Database running on Linux and one of our
> SQL-Servers.
>
> How do i achieve this ?
>
> If i understand the documentation correctly you have to program the
> replication mechanism for yourself or you have to use some third party
> tool.
>
> Could anyone please outline, how to set up the replication mechanism
> (pointing me to some web-site should be enough) and also tell me if
> there is any third party tool.
>
> Thanks in advance and greetings from Vienna
>
> Uli