By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,177 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

How do i replicate data from MySQL into SQL-Server

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.