I set up transaction replication for certain tables. I am getting the error:
Cannot insert explicit value for identity column in table '<tablename>' when IDENTITY_INSERT is set to OFF.
I see the cause of the issue. Publisher table is trying to dump the data to the Subscriber table where it's identity column is not allowing any data.
One way to workaround this issue is making the subscriber database's identity column not IDENTITY. but we have to keep both table's schema identical. Is there a configuration in the replication that I missed causing this issue? Surely Someone in the past would have wanted to keep the same value on both tables.
Any help is appreciated.