sql server replication: How to set up replication from SQL Server 2005 to MySQL through ODBC -- sql server replication

How to set up replication from SQL Server 2005 to MySQL through ODBC

ronald.debruin NO[at]SPAM ecorys.com
4/26/2007 6:57:28 AM

sql server replication:

Hi,

Can anyone please provide me with a step-by-step explanation on how to
replicate data (snapshot replication) from a table in a SQL Server
2005 database to a table in a MySQL database through an ODBC
connection?
I have already created a publication, but have not succeeded in
successfully adding a subscription. I know that I have to use the
stored procedures "sp_addsubscription" and
"sp_addpushsubscription_agent", but cannot figure out how to set up
the parameters to get it to work. Any help on this issue would be
greatly appreciated.

Thanks

Re: How to set up replication from SQL Server 2005 to MySQL through ODBC

Hilary Cotter
4/26/2007 12:58:05 PM

This is not supported in SQL 2005. It was in SQL 2000 but there was a bug
last time I checked.

[quoted text, click to view]