Distributed Primary Fragments Model

In a distributed primary fragments model, tables at each site contain both primary and replicated data.

Each site functions as a primary site for a particular subset of rows called a fragment. Updates to the primary fragment are distributed to other sites. Updates to nonprimary data are received from the primary sites of other fragments.

Applications that use the distributed primary fragments model have distributed tables that contain primary and replicated data. The Replication Server at each site distributes modifications made to local primary data to other sites and applies modifications received from other sites to the data that is replicated locally.

To replicate a table in the distributed primary fragments model, you must perform these tasks at each site:

Create a table in each database. The table should have the same structure in each database.
Create indexes and grant appropriate permissions on the tables.
Allow for replication on the tables using the sp_setreptable system procedure.
Create a replication definition for the table at each site.
At each site, create a subscription for the replication definition at the other sites. If n is the number of sites, create n-1 subscriptions.

Distributed Primary Fragments Model
Figure 3-3 shows an example of the distributed primary fragments model. Each of the three sites has a database, data server and replication server. Changes to fragments in each site flow to the other sites.

Figure 3-3 shows an example of the distributed primary fragments model. Each of the three sites has a database, data server and replication server. Changes to fragments in each site flow to the other sites.

This figure illustrates a salesdetail able set up with distributed primary fragments at three sites. Each site receives replicated data via two subscriptions.

Table with Three Distributed Primary Fragments
Figure 3-4 illustrates a sales detail table set up with distributed primary fragments at three sites. Each site receives replicated data via two subscriptions.

Figure 3-4 illustrates a sales detail table set up with distributed primary fragments at three sites. Each site receives replicated data via two subscriptions.