question

sangem avatar image
sangem asked

MSSQL replication question ,SQL REPLICATION :- I am setting up the replication from sql 2000 to sql 2008r2 on prem to cloud , snpshot is generating with out any issue and but some tables are failing applying on the subscriber , error message ,

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.

,

replication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.