Step 6: Test the Application

To test the application you have built:

1. Use the datecol column to see when rows were updated at each site, relative to each other.
2. Execute updates to the first row in test1 and test2 simultaneously:

   USE test1

   GO

   UPDATE two_way_test1 SET intcol = 20 , charcol = 'updated at test1' WHERE pkcol = 1

     

   USE test2

   GO

   UPDATE two_way_test2 SET intcol = 60 , charcol = 'updated at test2' WHERE pkcol = 1

     

If the starting value of intcol was 10, the value in test1 was incremented by 10 and the value in test2 was incremented by 50. The conflict resolution in the update custom procedure sums the values in this column, so this integer value converges to 70 in both databases.