Publication Properties, Data Partitions

The Data Partitions page of the Publication Properties dialog box allows you to define data partitions for merge publications that use parameterized filtering. After defining partitions, you can then generate snapshots for these partitions, providing different initial data sets for different Subscribers based on the connection properties (login and/or computer name) of the Subscribers. You can also select to allow Subscribers to request snapshot delivery and generation if they do not have a snapshot available for their partition the first time they synchronize. For more information, see How to: Generate a Snapshot for a Merge Publication with Parameterized Filters (SQL Server Management Studio).

Options

  • Add
    Click Add to define a partition. In the Add Data Partition dialog box, specify values for HOST_NAME() and/or SUSER_SNAME(), and define a schedule to refresh snapshots.
  • Edit
    Select an existing partition in the grid, and click Edit to edit the partition.
  • Delete
    Select an existing partition in the grid, and click Delete to delete the partition.
  • Generate the selected snapshots now
    Select one or more partitions in the grid, and click Generate the selected snapshots now to generate snapshots for these partitions.
  • Clean up the existing snapshots
    Select one or more partitions in the grid, and click Clean up the existing snapshots to clean up snapshots for these partitions.
  • Automatically define a partition and generate a snapshot if needed when a new Subscriber tries to synchronize
    Select this option if you want to allow Subscribers to request snapshot generation and application. Subscribers might require this option if they do not have a snapshot available for their partition the first time they synchronize.

See Also

Other Resources

How to: Create a Publication and Define Articles (SQL Server Management Studio)
How to: View and Modify Publication and Article Properties (SQL Server Management Studio)
Parameterized Row Filters
Publishing Data and Database Objects
Replication Properties
Replication Wizards
Snapshots for Merge Publications with Parameterized Filters

Help and Information

Getting SQL Server 2005 Assistance