UPDATETEXT error when running data compare for replication

jessy_chenjessy_chen Posts: 6

When we run data compare for replication, it results the following error.
not allowed because the column is being processed by a concurrent snapshot and
is being replicated to a non-SQL Server Subscriber or Published in a publicationallowing Data Transformation Services (DTS).

Our replication architecture is as the following
A -> B -> C1, C2, C3

Sql data compare : A -> B
Sql native replication : B -> C1, C2, C3

So B is target to sync data from A, and also a distributor to distribute data to C1, C2, C3.
The error happens in the job of A sync to B using sql data compare.

Please help on this issue. Thanks very much.


  • Thanks for your post.

    I think this message is telling you that you cannot use SQL Data Compare to sync the data while you are currently processing a snapshot.

    "UPDATETEXT statements cannot be performed on data marked for replication while it is being extracted during concurrent snapshot processing. If you initiate an UPDATETEXT statement, you will get an error indicating that the operation is not allowed because of concurrent snapshot processing. After the snapshot is complete, UPDATETEXT statements can be performed again."[http://msdn.microsoft.com/en-us/library/aa179423(SQL.80).aspx]

    This should mean that after you have completed the snapshot, SQL Data Compare should run ok.

    I hope this helps.
Sign In or Register to comment.