I have three servers with own databases, and database schemas are same. Let's call them servers A, B and C.
All three servers will be operational, which means that all three servers will serve for its region.
Data from servers B and C need to be replicated on server A, so that server A will contains data from all servers, but other two servers contain just own data.
I need to implement some replication solution to achieve this goal, and I am asking if it is possible to have two publishers (server B and C) and one server with two subscription (server A)? Is there any better solution? Which replication model will be the best?