Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    319

    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.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I think the answer you are searching for may be NOT FOR REPLICATION

    Hope this helps
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •