all groups > sql server replication > january 2005 >
You're in the

sql server replication

group:

Bidirectionnal replication between SQL 2000 and Sybase ASE


Re: Bidirectionnal replication between SQL 2000 and Sybase ASE Hilary Cotter
1/28/2005 9:30:58 AM
sql server replication:
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
[quoted text, click to view]

Bidirectionnal replication between SQL 2000 and Sybase ASE Steve B.
1/28/2005 2:52:14 PM
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

AddThis Social Bookmark Button