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.F80FD
...@pixelpark.com>...
>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