Multiple db Replication into a single db

• SQL_Student

  SSCrazy

  Points: 2536

  More actions

  September 7, 2012 at 2:32 am

  #393127

  Good day all

  I'd like to set up replication on Multiple databases on different servers so that it is replicated to a single database. At first I created two publishers on separate db's (db_1 and db_2) and created a subscription to both via the one db (db_replication). The first publisher pushed through all the data successfully through but when the second one was created it wiped out all the other data and replaced it with its data. I need multiple database data into one database. Could this be because I used transactional publication instead of transactional publication with updatable subscriptions / merge publication

  Please assist

• Sudhakar Vallamsetty

  SSC-Addicted

  Points: 407

  More actions

  September 7, 2012 at 5:42 am

  #1535009

  Try the above one and see if it serves your purpose!!!

  *******:cool:

  Sudhakar

  *******:cool:
  Sudhakar

• SQL_Student

  SSCrazy

  Points: 2536

  More actions

  September 7, 2012 at 7:48 am

  #1535065

  Thanks A lot, Will try that solution out soon, seems like I have the same issue.

  Sure it works the same way in SQL 2008 R2

  Thanks again