Post reply

Snapshot replication followed by transactional replication

  • May 8, 2006 at 2:04 pm

    #97063

     

    Hi!!

    I really need your help.

    I have the following scene:

    Publisher A, replicates to Subscriber B, using Snapshot replication.

    Subscriber B also becomes Publisher and replicates to Subscriber C, using Snapshot Replication.

     

    But I change it to:

    Publisher A, replicates to Subscriber B, using Snapshot replication.

    Subscriber B also becomes Publisher and replicates to Subscriber C, using Transactional Replication.

     

    But I cann't get it right

    i have problems with the IDENTITY property and the column PK

    and i have problems with the name conflicts of tables.. i tryed to change article defaultss...

    Please help me

    Thanks

    Cláudia

     

    Regards,

    Cláudia Rego

    www.footballbesttips.com

  • May 9, 2006 at 7:50 am

    #636743

    Hello,

    All the tables involved in a Transactional Replication must have a PK defined on it.... so, if you need to replicate B to C through transactional replication maybe you must define a PK in A.

    But there is something that is not clear for me,.... if you made a Snapshot replication between A and B with a given schedule.... and the same tables are replicated from B to C. I don't see the need for change the snapshot replication into a transactional one.

    Regards,

    Gustavo.

  • May 9, 2006 at 8:27 am

    #636762

    Because replication from B to C uses the LAN (128kbps) and the volume of data is big(near 1 Gb)!!

    Regards,

    Cláudia Rego

    www.footballbesttips.com

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

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