Post reply

Primary Key

  • May 26, 2006 at 10:33 am

    #91114

    Hello again,

    How can we manage primary key in replication where entries can be arrive from any subscribers at any time? By putting the prefix in the key we can survive but how can we use BIGINT as primary key (without identity insert and scope)?

    Thanks Govind

     

  • May 29, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • May 29, 2006 at 8:04 pm

    #640594

    If you are not interested in the actual value other than as a link to other records, I can highly recommend that you use UNIQUEIDENTIFIER as your datatype.

    Failing that, you probably need to seed the ranges for each subscriber.

    You could consider using a mutli column primary key allowing you to have a unique identification for each subscriber.

    It all comes down to how you design your database.

    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply