This SQL
Replication Application demonstrates how to duplicate table schemas and data
from the Pubs Database on ServerP to the Pubs Database on ServerS.
ServerP is the Publisher and ServerS is the Subscriber. The Authors and
Employee tables
will be replicated. These tables will be set up as Publication/Articles.
Additional tables can be added or existing tables may be removed.
ServerP and ServerS are running
Windows NT 4.0 (SP3) with SQL Server 6.5 (SP5A).
To become
familiar with the replication terminology refer to Microsoft’s Books Online
Document titled ‘Replication Terminology’. Before you set up
Replication refer to Microsoft’s Books Online Document titled ‘Before
Setting Up Replication’.