SQL Serever Replication – Setup and configure the Publication on SQL Server 2000 – Part 3 of 4

In part 2, we have configured a SQL Server as a main publishing server, we have to create a publication of databases which the clients can subscribe.

Click on New Publication

“Create Publication Wizard” starts, check the “Show advanced options in this Wizard” checkbox and press “Next”

After please select your database and press “Next”

In the “Select Publication Type” screen select “Transactional publication” (second option) en press “Next”

On the “Specify Articles” Screen check all the checkboxes on the left, selecting all tables, and views as articles and press “Next”

Warning screen appears

Give the Publication a Name then Press “Next”

 Customize the properties of this publication, select “Yes” and press “Next”.

In the “filter data” screen we leave both specific record or column filtering should be applied on the replication data.

 In the “Allow Anonymous Subscriptions” choose “Yes” and press “Next”

 The “Set Snapshot Agent Schedule” screen defines a schedule how often and when initial snapshots (initial copies of the main database) should be created in the replication file share.

Check “Create the first Snapshot immediately” and press “Next”

 Wait for the publication process to finish.

Reference URL
http://varindersandhu.in/2011/08/12/sql-server-how-to-setup-sql-server-replication/