SQL Server - Transactional Replication - Configuring Publisher

As mentioned in my previous post, In this post, let us see step by step tutorial in configuring publisher at server 2

In SSMS - > Under Object Explorer - > Replication - > Local Publications -> New Publication...




Click Add... and map to Server 1 which is configured as Distributor :



Select Publication Database :





Select objects to be published :



Filter Published Data





Snapshot Agent Security



Provide the path for saving configuration scripts and click Finish:

See Also:

•   My posts on SQL Server administration