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.

01 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

Click on New Publication

02 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

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

After please select your database and press “Next”

03 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

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

04 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

05 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

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

06 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

Warning screen appears

07 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

Give the Publication a Name then Press “Next”

08 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

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

09 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

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

10 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

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

11 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

 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”

12 Setup and configure the Publication

Setup and configure the Publication by www.varindersandhu.in

 Wait for the publication process to finish.

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