Skip to content

Commit 1edd48c

Browse files
authored
Merge pull request MicrosoftDocs#520 from TurekBot/patch-5
An extra word
2 parents fb80aaa + 298a3cb commit 1edd48c

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/relational-databases/track-changes/track-data-changes-sql-server.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -141,7 +141,7 @@ ms.workload: "Active"
141141
## <a name="Tracking"></a> Change Tracking
142142
Change tracking captures the fact that rows in a table were changed, but does not capture the data that was changed. This enables applications to determine the rows that have changed with the latest row data being obtained directly from the user tables. Therefore, change tracking is more limited in the historical questions it can answer compared to change data capture. However, for those applications that do not require the historical information, there is far less storage overhead because of the changed data not being captured. A synchronous tracking mechanism is used to track the changes. This has been designed to have minimal overhead to the DML operations.
143143

144-
The following illustration shows a synchronization scenario that would benefit by using change tracking. In the scenario, an application requires the following information: all the rows in the table that were changed since in the last time that the table was synchronized, and only the current row data. Because a synchronous mechanism is used to track the changes, an application can perform two-way synchronization and reliably detect any conflicts that might have occurred.
144+
The following illustration shows a synchronization scenario that would benefit by using change tracking. In the scenario, an application requires the following information: all the rows in the table that were changed since the last time that the table was synchronized, and only the current row data. Because a synchronous mechanism is used to track the changes, an application can perform two-way synchronization and reliably detect any conflicts that might have occurred.
145145

146146
![Conceptual illustration of change tracking](../../relational-databases/track-changes/media/cdcart2.gif "Conceptual illustration of change tracking")
147147

0 commit comments

Comments
 (0)