All,

I am in need of a recommended method of sync'ing/replicating data between
two dataservers. Replication server is not available because I do not
have a license for it on my production system (please correct me if this
is not the case--this seems to be the most obvious way).

Server A (production) contains an number of databases. For this purpose
of this email, I want to sync/replicate one of the databases called
'prdds01' to Server B (development) on database 'devds01'.

Database prdds01 and devds01 are to be exactly the same *except* the
server/database names defined within sybase.

Server A running prdds01 is a Solaris box with ASE 12.0.
Server B running devds01 is a Linux box with ASE 12.5.1.

I have attempted to setup SQLRemote by blindly following:

http://manuals.sybase.com/onlinebook...w;pt=5002;nh=1

But all attempts fail. I *almost* get finished but run into a problem:

1> sp_add_remote_table my_table
2> go
Table my_table does not have a unique or primary key
(return status = 1)

Okay, so none of my tables have unique or primary keys from a quick glance
from Sybase Central. Why is it a requirement to have a unique or primary
key on a table?

Any thoughts as to make this process easier or better directions to
follow?

TIA,

Ryan