Articles (DMM)

An article is the basic unit of replication and contains either a table or a view to replicate. Articles are gathered together into a publication to be replicated by the replication process. Articles have no symbol in the diagram, but are listed on the Articles tab of a publication property sheet.

An article can contain the following items:

Columns – contains the table or view columns to replicate (see Columns (DMM)).
Scripts – specify instructions for executing a specific function in a database (see Event Scripts (DMM)).
Where Clauses – let you filter rows out of an article to publish.

In the following example, the Contact and Customer articles contain tables with the same names and are included in the Glasgow publication:

article example

Adding or Removing Articles from a Publication
You can create or delete an article using the tools available on the Articles tab of a publication property.
Article Properties
To view or edit an article's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

Parent topic: Data Movement Diagrams