Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    Question Unanswered: replication SQLServer 2-way

    We have 2 SQLServer-databases with the same table in it. In both databases the table can be updated by users.

    Is is possible to replicate the updates in this table from the one database to the other and vice versa? We want to use transactional-replication.

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: replication SQLServer 2-way

    You can setup an updatable transactional replication. To do that, specify 'true' to the paramenter @allow_sync_tran when you execute sp_addpublication. And @update_mode = 'sync tran' when you execute sp_addsubscription.

  3. #3
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    Just out of curiousity, why can't he use merge replication instead?
    I'm still learning from this replication thing...is there any reasons for chosing transactional against merge for this purpose?
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  4. #4
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    My personal experience in both merge and updatable transactional is that merge is slower, and it take a lot more to setup and manage. You can treat updatable transactional just like the regular transactional replication with a couple of more parameters to setup. There are other minor reasons but the main thing is the simplicity and better performance of transactional replication.

    Hope this helps.

  5. #5
    Join Date
    Aug 2002
    Posts
    2
    joejcheng,

    We tried the solution you provided and it works fine now. Thank you for your information.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •