The image shows this update conflict:
| Steps | On Database A | On Database B |
|---|---|---|
|
Initial condition. |
X is 1. |
X is 1. |
|
The application on each database updates X simultaneously. |
Set X=2. |
Set X=100. |
|
The replication agent on each database sends its update to the other database. |
Replicate X to Database B |
Replicate X to Database A. |
|
Each database now has the other's update. |
Replication says to set X=100. |
Replication says to set X=2. |
End of description.