Merge and transactional replication

• Viky

  SSC-Addicted

  Points: 465

  More actions

  September 16, 2009 at 5:21 pm

  #210931

  I have a merge replication working very well.

  Is it possible to configure a transactional replication with this merge replication ?

  For example I have databases A, B, C configured with merge replication .

  But the database D I need only to inserts records in the database A. And this records inserts in B and C too, this is possible because the merge replication do it.

  But to make database D inserts in database A I need to configure transactional replication.

  If I create a snapshot of database D in the configuration, what happened to the database A and its merge replication?

  Thanks a lot

  Viky

• Pradyothana Shastry

  SSCertifiable

  Points: 5211

  More actions

  September 18, 2009 at 5:11 am

  #1055503

  A, B and C are the databases and you have a snap shot agent for database A. A is your publisher and D is your subscriber then we can do that.

  
  - Pradyothana http://www.msqlserver.com