UPDATETEXT error when running data compare for replication
jessy_chen
Posts: 6
Hi,
When we run data compare for replication, it results the following error.
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.
When we run data compare for replication, it results the following error.
UPDATETEXT is
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.
Comments
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.