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:

No comments: