Overview

SQL Server 2005 Replication Creating a Publication

The Publication
Once you’ve configured a distributor, you’re ready to create publications. To invoke the publication wizard, right-click the local publications folder and choose New Publication from the pop-up menu. As with the Distribution Configuration Wizard, the first screen of this wizard is introductory in nature and can be skipped. The second screen allows you to choose the database in which you want to create a publication. After selecting the database, you must choose the publication type. The wizard offers the following options:

• Snapshot Publication
• Transactional Publication
• Transactional Publication with Updatable Subscriptions
• Merge Publication

• Right-click on Replication folder, and then click New Publication.

• On the New Publication Wizard page, click Next.

• Select the Publication Database and click Next.

• On the Publication Type page, click Merge publication, and then click Next.

A replication topology defines the relationship between servers and copies of data and clarifies the logic that determines how data flows between servers. There are several replication processes (referred to as agents) that are responsible for copying and moving data between the Publisher and Subscribers. The following figure; provides an overview of the components and processes involved in merge replication.

• Check SQL Server 2005, on the Subscriber Types page and click Next.

• Unselect “Counters” table and select all the remaining tables and then click Next.

• On the Article Issues page, click Next.

• On the Filter Table Rows page, click Next.

• On the Snapshot Agent page, click Next.

• On the Agent Security page, click Security Settings

• On the Snapshot Agent Security page, select Run under the SQL Server Agent account and Select the SQL Server login and click Next.

• On the Agent Security page, click Next.

• On the Wizard Actions page, click Next.

• On the Complete the Wizard page, enter a Publication name, and then click Finish.

• When the publication is successfully created, click Close.

• Restart the Snapshot Agent