We have setup transactional replications between two servers (Publisher and Subscriber).
The publishing database is more than several GBs. We can setup up one large Publication but if we reinitialize a snapshot or Subscriptions, it can take hours.
Therefore, we can create several smaller Publications. What would be the con vs pro for this?
Feel free to share your replication practices too.
Thanks