We currently have SQL Server 2000 and have merge replication. We have the following process
1. Data is transfered to a laptop, data on the laptop is changed and the data on the server is 'locked'
no changes can be made.
2. After a few days, the laptop is returned to the office.
3. A script is ran to delete the data on the publisher. Replication works,
the subscriber side is updated with the change (no data in the tables).
4. A DTS package is then ran to transfer the data from the laptop to the publisher.
Replication does not work at this time, Data exists on the publisher side, but not the subscriber side
The replication monitor detial session does not indicate there are any problems and appears to be
running like normal.
5. The same DTS package was then ran on the subscriber side to get the data there. This worked.
We now run into the following problem when trying to delete a row out of one of
the tables. Cannot insert duplicate key row in object "MSmerge_tombst one'
with unique index 'uc1MSmerge_tom bstone' The statement has been terminated.
My first question is why does the replication not work when the DTS package is ran?
The second question is, any ideas why we can not delete a row out of the table?
Thanks
Tsharp
1. Data is transfered to a laptop, data on the laptop is changed and the data on the server is 'locked'
no changes can be made.
2. After a few days, the laptop is returned to the office.
3. A script is ran to delete the data on the publisher. Replication works,
the subscriber side is updated with the change (no data in the tables).
4. A DTS package is then ran to transfer the data from the laptop to the publisher.
Replication does not work at this time, Data exists on the publisher side, but not the subscriber side
The replication monitor detial session does not indicate there are any problems and appears to be
running like normal.
5. The same DTS package was then ran on the subscriber side to get the data there. This worked.
We now run into the following problem when trying to delete a row out of one of
the tables. Cannot insert duplicate key row in object "MSmerge_tombst one'
with unique index 'uc1MSmerge_tom bstone' The statement has been terminated.
My first question is why does the replication not work when the DTS package is ran?
The second question is, any ideas why we can not delete a row out of the table?
Thanks
Tsharp