I am trying to perform replication from Sybase ASE 15.5
to Sybase ASE 15.5
for a list of given tables via replication definitions and subscriptions defined in Replication Server(REP) Version 15.7.1
. I found out that there is a table with one of the columns defined as IDENTITY
. After creating the replication definition and subscription for that table, I am getting the below error messages in replication server:
Message from server: Message: 584, State 1, Severity 16 -- 'Explicit value specified for identity field in table 'customers' when 'SET IDENTITY_INSERT' is OFF'.
I have tried to run SET IDENTITY_INSERT customers ON
on both of my primary and replicate database, but no luck.
Appreciate if you could help. Thanks!