Post reply

Can we implement

  • September 10, 2011 at 4:47 pm

    #257149

    Hi

    can we implement snapshot replication using the snapshot that is generated by Transactional Replication?

    Thanks,

    Ravi

  • September 10, 2011 at 4:54 pm

    #1379639

    yes. even in transactional replication, this is how you initiatlize the subscriber. all future modifications is read by log reader agent for the published articles.


    Pradeep Singh

  • September 10, 2011 at 5:32 pm

    #1379649

    Thanks Pradeep, do you have any documentation how this is implemented can you please forward it to me.

  • September 10, 2011 at 6:20 pm

    #1379652

    snapshot created by the transaction replication can be applied directly to the subscriber (bypassing distributor). I hope you wish to apply the snapshot to a subscriber which is different from the one using transaction replication..

    snapshot contain schema creation scripts and table data (bcp'ed out). you can directly apply them on the target(subscriber).

    see the link below

    http://www.sqlservercentral.com/articles/Replication/snapshotreplication/819/


    Pradeep Singh

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

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