SQLA to SQLA Replication using OSG and Sybase Replication Server

[Heiko Höfer]

Hi there;

so I'm trying to figure out, whether it is possible to let a Sybase
Replication Server take care of a replication between two SQL Anywhere
databases. The idea is to use asynchronous procedure calls between an
primary SQL Anywhere database and a replicate SQL Anywhere database.
This should resolve my primary key index problems when I insert new
records into both databases at the same time. At the replicate database
I would like to use requested asynchronous procedure calls to get rid of
this problem. Unfortunately the generic SQL Anywhere Remote Message
Agent isn't capable of this problem, though I can alter stored
procedures in a SQL Anywhere database an set REPLICATE ON. Did someone
ever implemented replication between SQLA databases using Sybase
Replication Server via the Open Server Gateway?

Thanks for any hint

Heiko

[Rob Waywell]

Yes it works. We have several people replication SQLA to SQLA via Rep
Server. I would argue that the preferred approach is to design out PK
conflicts as opposed to trying to handle them after the fact.

--

---------------------------------------
Rob Waywell
Sybase
Please Respond to Newsgroups
Heiko Höfer wrote in message <36D69298...@pixelpark.com>...