Abstract
This chapter focuses on two core techniques that allow you to detect modifications to source data and consequently update a destination table with the corresponding changes. Using their most simplistic definitions, these techniques are
-
Change Tracking: Detects that a row has changed. Lets a process return the latest version of the data from the source table.
-
Change Data Capture: Detects that a row has changed. Stores all the intermediate changes, as well as the final state of a record.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Adam Aspin
About this chapter
Cite this chapter
Aspin, A. (2012). Change Tracking and Change Data Capture. In: SQL Server 2012 Data Integration Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4792-0_12
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4792-0_12
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4791-3
Online ISBN: 978-1-4302-4792-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books