Sample Header Ad - 728x90

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