Post reply

Inital Snapshot versus DTS for first database transfer

  • March 21, 2006 at 7:19 am

    #168787

    Quic questuion to all. What are the pros and cons about running DTS to send all the data for the first time instead of using snapshot to initiate replication?

    Due to the time used by the snapshot isn't it better to run a DTS for each database to be replicated? New to replication and was wondering if this is possible. Thank you

  • March 21, 2006 at 9:59 pm

    #628014

    It depends on what Replication Model you will Implement!

    1. If it's just Snapshot then I suppose you can use DTS to copy the Initial Database and then set it up to for Replication. (I personally do not see any point in that)
    2. If it Transactional then you can do the same as option 1 although if you are implementing Immediate Updating Subscribers it might pose a challenge!
    3. If its Merge then its probably best if Replication does the initial snapshot.

    Kindest Regards,

  • March 22, 2006 at 5:19 am

    #628053

    Thanks for your input. We decided to go with transactional from the beginning and avoid any issues using DTS

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

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