Multiple forms of replication for a database

• Josh B

  SSCrazy

  Points: 2426

  More actions

  February 29, 2012 at 10:32 am

  #269233

  We're looking into using merge replication on one of databases, which is already setup for transactional replication. I havne't yet found any information on whether or not it will work to have the same database transactionally replicate to server A and also to use merge replication with server B. Anyone have any experience with this?

  Thanks,

  Josh

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  February 29, 2012 at 3:30 pm

  #1453398

  You can absolutely do that, yes.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  March 16, 2012 at 5:12 am

  #1460427

  Yes..we have a database that is a merge subscriber and is republished as a transactional publisher..no problems.

  You may want to have a think about how you want it to work as the two replicate with different rules

  HTH

  Graeme