Hi Everyone,

We need to replicate multiple databases (publications) to one central subscriber. The schema of those articles are identical in all publications and also the primary keys in publications do not have any overlap. Is this possible?If yes is there any specific thaing that I should consider for it's implementation? Should each publication has it's own dedicated ditributer or all of them can share one distributer?

Thanks

Aspet

You can use transactional replication for this.

The trick is to ensure that the action name if in use property is set to delete matching data, and that you have a row filter on all published articles so that when you reinitialize you will not wipe out data from a different publication.  You should add a default to all tables being replication called Location (for example) which would default to @@ServerName.

This way you can filter data on the @@ServerName filter, so that when you reinitialize only the data from that server will be deleted on the central subscriber.