Company
Date Published
Author
CData Software
Word count
607
Language
English
Hacker News points
None

Summary

Batch replication is a type of data replication that appends all data from the source view/table to the target table, with the option to prevent duplicate records. It differs from other types of replication in that old rows in the target table can be kept even if they were deleted in the source table, and updates can be performed on current rows while inserted rows are added to the target table. This method is useful when you want to keep track of changes but don't need to track every single row, such as with customer information where only certain fields need updating. Batch replication can also be used with or without an identity field, with the latter providing a way to keep track of changes while avoiding duplicates. CData Virtuality offers batch replication as part of its data virtualization and replication capabilities, allowing for high-performance real-time data integration and master data management through advanced ETL.