Problem replicating IDENTITY columns from Sybase ASE 15.5 to Sybase ASE 15.5
0
votes
1
answer
1294
views
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!
Asked by Tittus
(33 rep)
Feb 12, 2018, 06:33 AM
Last activity: May 10, 2021, 09:09 AM
Last activity: May 10, 2021, 09:09 AM