Pushing New Customers To All Other Replicating Tracks
Search
Pushing New Customers To All Other Replicating Tracks
Overview
This is useful when a new track comes online and has a database that the other tracks do not.
For instance: A large chain buys a competitor and wants to sync the competitor's database into the large chain's database.
Prereq: The customers are already on a unique ID range and replication is already setup and active.
SQL Statement
This SQL statement can be run at the "new" track and will push all customers into replicating to the other locations. Ensure the two updated replication stored procedures, found attached to Catching Up a Track on Replication, have been run (Except Team Sport). This will ensure the replication engine works on smaller chunks of data.