Prev: Err:The merge process could not enumerate deletions at the 'Pu
Next: snapshot agent not running
From: ronald.debruin on 26 Apr 2007 09:57
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

From: Hilary Cotter on 26 Apr 2007 12:58
This is not supported in SQL 2005. It was in SQL 2000 but there was a bug
last time I checked.


<ronald.debruin(a)ecorys.com> wrote in message
news:1177595848.403994.88300(a)n35g2000prd.googlegroups.com...
> 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
>


 | 
Pages: 1
Prev: Err:The merge process could not enumerate deletions at the 'Pu
Next: snapshot agent not running