467,184 Members | 1,307 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,184 developers. It's quick & easy.

How do i replicate data from MySQL into SQL-Server

Uli
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
Jul 23 '05 #1
  • viewed: 1517
Share:
1 Reply
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" <ul*********@lycos.at> wrote in message
news:76**************************@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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Bruce A. Julseth | last post: by
12 posts views Thread by Jerry Weinstein | last post: by
2 posts views Thread by Bruce W...1 | last post: by
reply views Thread by David Linsin | last post: by
7 posts views Thread by sathyashrayan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.