Unanswered: can you split 1 large publication into 2?
One problem we face is that as our merge replication publication grows it is increasingly taking longer and longer to snapshot particularly due to 1 or 2 tables (out of 360).
I am considering creating a 2nd publication so as to split the large current one we have. My concern has to do with FK's. Do all tables that are connected via FK's need to be in the same publication or can they exist in a 2nd publication? I think if I try to break it out that we will get errors as data from 1 publication is replicated prior to the other and causing an FK violation.