Guide to MS SQL 2008 Transactional Replication (Create Publisher) Part-III

Publisher is the Primary or Master server which host the original data or database where actual or real-time changes/updates are made. In this Post I am going to explain how to configure Publisher.

Amplify’d from eitwebguru.com

Read more at eitwebguru.com

After you configure the Distributor Server (Guide to MS SQL 2008 Transactional Replication (Configure Distributor) Part-II) now I will explain how you can create & configure the Publisher.

Read more at eitwebguru.com

Create & Configure Publisher

1) Select the Transactional Databases: Login to MSSQL Management Studio and go to  Server >> Replication (right Click) >> Publisher Properties >> Publication Databases >> Select the database you want as Transactional Database and press OK.

14 300x268 Guide to MS SQL 2008 Transactional Replication (Create Publisher) Part III

2) Now under Replication Right click on Local Publication and select “New Publication…

15 300x227 Guide to MS SQL 2008 Transactional Replication (Create Publisher) Part III

3) New Publication Wizard window will open; Press Next.

16 300x270 Guide to MS SQL 2008 Transactional Replication (Create Publisher) Part III

4) Publication Database: Select the database you want to publish and click on Next.

17 300x268 Guide to MS SQL 2008 Transactional Replication (Create Publisher) Part III

5) Publication type: You have to select the publication type you want to create. Select “Transactional Publication” and click on Next.

18 300x268 Guide to MS SQL 2008 Transactional Replication (Create Publisher) Part III

6) Articles: You have to select the objects which will be published. If you have stored procedures and views in your table you can either publish along with views or stored procedure.

19 300x268 Guide to MS SQL 2008 Transactional Replication (Create Publisher) Part III

7) Filter Table Rows: If you want to filter rows or don’t want to publish any row you can add filter here or you can just press Next without adding filter.

Read more at eitwebguru.com

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s