Post reply

Snapshot replication & Identity Crisis

  • October 27, 2005 at 9:55 am

    #188234

    Hi All:

    I'm rather new to SQL and snapshot replication.  In order to learn more about it I've read the articles.  I ran across one article by Hilary Cotter about "The Identity Crisis in Replication".

    The article refers to use of the "IDENTITY" column in tables and replication.

    In my case, I'd like to use snapshot replication.  I have a handful of tables that use the "IDENTITY" column.  By design, we will NEVER be making updates to the "subscriber".

    With my knowledge to date, I'm not sure if I need to be concerned with this based on the design.

    Please help me

    Thanks, Bill

     

     

  • October 28, 2005 at 8:29 am

    #600925

    You should be fine. Managing identities is really only a concern when you are doing bi-directional replication.

  • November 2, 2005 at 12:00 am

    #601749

    Hi Bill,

    If you are using snapshot replication that is the easiest to deal with. All you will be doing is taking a copy of the data and placing it on the subscriber. All you need to do is set the frequency of the distribution.

    Regards..Graeme

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

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