sql - replication multiple databases into one database -


before question want explain i'm trying do. i'm using sql server 2016 , have 2 databases

databasea  databaseb 

in remote server created same databases using same creation sql scripts used databasea , databaseb. used replication service sql server 2016. local database publisher , remote server subscriber.

this worked fine. want having 1 database in remote server contains tables both databases , 2 databases replicate corresponding tables.

for example

[databasea].[dbo].[tablea] ---is replicated into-->[aggregateddatabase].[dbo].[tablea]  [databaseb].[dbo].[tableb] ---is replicated into-->[aggregateddatabase].[dbo].[tableb] 

is possible? if yes how else other options i'm looking for?

yes,it possible..two different publishers can have 1 subscriber..

if yes how

just set way set replication , while selecting subscriber choose aggregated database


Comments

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -