Applicable Uses for Transactional Replication
Different types of applications are complimented by transactional replication. In an environment where data needs to be distributed with little latency, transaction replication is well suited for the task.
In a manufacturing setting, different divisions within a facility might collect production data. Those divisions within that facility would then distribute their data to a central collection point for reporting. Taking that scenario one step further, the collection of data from multiple factories could be distributed to a centralized location for further analysis and reporting.
A bank with branch offices would be a well suited candidate for transactional replication. Each branch keeps track of its ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
