I have a database on SQL Server A & one on SQL Server B. (SQL 2017 w/ enterprise) They share similar objects and need to be kept fairly up to date. Both will require changes to be passed to each of them, however these changes will be different. Should I setup transactional replication to go from server A to server B and then setup another publication to go back from server B to server A with the different criteria? I've never had to replicate different items from the replica. So that is why I am unsure here. Any comments are appreciated. I don't think Peer-to-Peer is the solution here as some objects will be different and/or not needed to be replicated between the 2 db's.
Asked
Active
Viewed 117 times
