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