Consult master data synchronization issues

batitotti

Error details: Only when the list of columns is used and IDENTITY_INSERT is ON, can you specify an explicit value for the identity column in the table'net_http'.
(Source: LVKY (data source); Error code: 8101)

Set the database parameter IDENTITY_INSERT to on, and that's it

德鲁伊

In this case, the replication agent will not be able to copy the new row to library B, because the column ID is an identification column and cannot provide a value for the identification column, and the replication fails.
   At this time, you need to set the NOT FOR REPLICATION option for the identity column. In this way, when the replication agent uses any login to connect to the table T_test on the library B, all the NOT FOR REPLICATION options on the table will be activated and the ID column can be inserted explicitly.

独行风中

Thank you all for your enthusiastic answers, thanks!!!