Republishing Subscriber Scenario | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Republishing Subscriber Scenario

Have a situation in which there is a central publisher which replicates thru Transactional Replication to 50 subscribers. Distributor runs one of the subscriber servers.
I need to add 40 more subscribers and this distributor has limitations with the number of worker threads and performance issues. I would like add to this replication topology with another publishing subscriber which can push to the 40 new subscribers. I have issues creating this republishing subscriber with the same schema. Like I am not able to create tables on this republishing subscriber with Primary keys and identity cols etc…By default when the tables are getting created on this republishing subscriber, they are dropped and the PK constraints are not enabled. Need some advice here. Thanks.
Try using a script to enable those constraints, MSDN link fyi. HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.