Replication

To organize data replication tasks in SQL Server 2000, a Replication folder has been added. Replication can be configured by right-clicking the replication folder and selecting Configure Publishing, Subscribers, and Distribution. Replication is the process of transferring data between servers. The source of the data is known as the publication and the receiver is known as the subscriber. Two subfolders manage these entities.

Publications

To create a publication or manage an existing one, select the Publication folder. Selecting New Publication from the right-click pop-up menu will start a replication wizard to step you through the task. After a publication is created, it can be managed through its properties page.

Subscriptions

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.