Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    13

    Unanswered: Merge Replication

    Hi,
    I have a problem when doing merge replication. I need to have a identity column on both the publisher and subscriber, eg id. When the publisher is down, my app will now reference to the subscriber and insert into the subscriber. However when the publisher is up, the app will reference to publisher and start to insert into the publisher. This will cause conflict in the id. Also, i need the id to be in running order, therefore i cant use range for publisher and subscriber. Anyone have idea how to solve this problem?



    Aaron

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, don't try it.

    Identity values need to be unique, but nothing guarantees they'll be sequential, even on a single server. Use GUID values. They scale better, are safer, and tend to discourage most bad practices.

    -PatP

  3. #3
    Join Date
    Jan 2006
    Posts
    13
    wat about using custom conflict management? if the 2 ids are conflicting, do an insert on the later row....

Posting Permissions

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