THe replication Replication changes the set based operation on the source database to row-by-row changes on the target database. SQL This is true for all replication based solutions.
SQL issued on the source database can change arbitrary number of rows, Dbvisit Replicate will only affect changes made to individual rows on the target database. . This is mined by Dbvisit Replicate as row-by-row changes, and the changes are applied at the target database as row-by-row changes, only affecting one row at a time.
The consequence is that the SQL issued at the apply database is not the same issued against mine – instead, each SQL updates/deletes/inserts exactly one row, applying just one change.
Definition of a conflict
If either one or more of the following are true, then a conflict is raised:
...