Updatable Queued Transaction Replication Conflicts
We are currently developing a project that uses updatable queued transaction replication with SQL Server as the main database and SQL Server Express on the clients. The replication is working properly with updates going both ways.
We have also tested that synchronization conflicts are correctly identified and are configured to be stored on the subscriber. The replication is configured so that the publisher wins (keep publisher data) and the conflicting subscriber data is stored in the subscriber database in the corresponding conflict table. We wanted the subscribers to have the conflict data and are trying to program a user interface so that the user that entered the conflict would be the one that could have a look and decide how to correct the conflict.
Our problem is gathering the conflict table entries so we can show them in a user interface. We are trying to use the following code:
Imports
System.Data.SqlClientImports
Microsoft.SqlServer.ReplicationImports
Microsoft.SqlServer.Management.CommonFriendSharedFunction ConflictGetter()As ArrayList
Dim connectionAsNew ServerConnection(Subscription.Connection)
connection.Connect()
Dim objDatabaseAs ReplicationDatabase =New ReplicationDatabase(Subscription.Publication, connection)
Dim objConflictsAsObject = objDatabase.EnumTransConflictCounts(Subscription.Publication, Subscription.Publisher, Subscription.PublisherDB)
connection.Disconnect()
ReturnTryCast(objConflicts, ArrayList)
EndFunction
The array list returned is empty, but if we use SQL Management Express, we can find the conflict table and see the row within the table with the conflict data.
Is there something wrong with the above routine, or should we be using something different than the EnumTransConflictCounts. The available help for this routine seems short and lacks an example.
Thank you for your help;
