How to: Specify That a Merge Table Article is Download-Only (SQL Server Management Studio)

Specify that an article is download-only on the Articles page of the New Publication Wizard or the Properties tab of the Article Properties - <Article> dialog box. This dialog box is available in the New Publication Wizard and the Publication Properties - <Publication> dialog box. For more information about using the wizard and accessing the dialog box, see How to: Create a Publication and Define Articles (SQL Server Management Studio) and How to: View and Modify Publication and Article Properties (SQL Server Management Studio).

Note

If you specify that an article is download-only after subscriptions have been initialized, all client subscriptions that received the article must be reinitialized. Server subscriptions do not have to be reinitialized. For more information on the effects of property changes, see Changing Publication and Article Properties.

To specify that an article is download-only on the Articles page

  • On the Articles page of the New Publication Wizard select a table, and then select the checkbox Highlighted table is download-only.

To specify that an article is download-only on the Properties tab of the Article Properties - <Article> dialog box

  1. On the Articles page of the New Publication Wizard or the Publication Properties - <Publication> dialog box, select a table, and then click Article Properties.

  2. Click Set Properties of Highlighted Table Article or Set Properties of All Table Articles.

  3. In the Destination Object section of the Properties tab of the Article Properties - <Article> dialog box, specify one of the following values for Synchronization direction:

    • Download to Subscriber, prohibit Subscriber changes

    • Download to Subscriber, allow Subscriber changes

  4. If you are in the Publication Properties - <Publication> dialog box, click OK to save and close the dialog box.