Sunday, March 11, 2012

Bidirectionnal replication between SQL 2000 and Sybase ASE

Hello,
For political reasons, I need to havec datas stored both on a SQL Server
2000 and a Sybase ASE v12.
If data changes in SQL, it must be replicated to the Sybase server, and if
data changes in Sybase, it must be propagated to the SQL Server.
Do you know how can I reach my goal in a simple manner ?
Thanks,
Steve
Does Sybase replicate to heterogeneous data sources (like SQL Server) using
stored procs? If so:
The best way to do this is to add a column to the tables you are replicating
called ServerName, or something like this. Then assign this column a default
of @.@.servername (I believe this option is available in Sybase).
Then modify update and delete the procs to do their work if the value of
servename being passed in the proc variable is not equal to the value in the
underlying column.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steve B." <steve_beauge@.com.msn.Swap.dotcom.and.msn> wrote in message
news:41fa438e$0$2068$626a14ce@.news.free.fr...
> Hello,
> For political reasons, I need to havec datas stored both on a SQL Server
> 2000 and a Sybase ASE v12.
> If data changes in SQL, it must be replicated to the Sybase server, and if
> data changes in Sybase, it must be propagated to the SQL Server.
> Do you know how can I reach my goal in a simple manner ?
> Thanks,
> Steve
>

No comments:

Post a Comment