Replication is designed as a data distribution mechanism. At the most basic level, changes made to one database are distributed to one or more targets. The core replication engine is designed for very flexible implementation, but the core architecture can be leveraged to provide availability for a database because a redundant copy of data is maintained in synchronization with a master copy.
The data to be replicated is defined by using three core components in the definition.
An article is the basic building block of replication and defines the most granular level of data distribution. An article can be defined against a table, view, stored procedure, or function.
The type of article that is most relevant ...