I am trying to setup the one way transactional replication from on-prem to cloud and versions are mssql 2000 to mssql 2008r2 .SNAPSHOT runs fine but having issue while applying on the subscriber and it happens on few tables
Error messages: Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the following two rows: primary key of first row: (JOBQUEUESETUP), primary key of second row: (JOB-REGISTER). (Source: MSSQLServer, Error number: 4819) Get help: http://help/4819
Appreciate the inputs here.