Saturday, August 20, 2011

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
 


0 comments:

About This Blog

The Windows Registry is a database which stores settings and options for Microsoft Windows operating systems. It contains normally information and settings for hardware, operating system software, most non-operating system software, and per-user settings. Registry is used to optimize the security, enhance the functionality, modify the functioning of any software OR settings and many more.

In this blog I have tried to collect all the tweaks and hacks available on various website. I have tested many of these hacks before posting but still I would suggest you to take backup of your registry before trying any of these tweaks and if anything goes wrong while trying these hacks I or this blog will not be held responsible.

  © Blogger templates The Professional Template by Ourblogtemplates.com 2008

Back to TOP