Garry Bargsley troubleshoots a transactional replication issue:
Use transactional replication to replicate similar data from four databases to one Azure DB. This sounds pretty straightforward for anyone who has done any replication work.
However, once I had everything setup and working, things stopped working, and it was a head-scratcher as to why. I made the proper settings configurations on each article, or so I thought. Let me show you the scenario in more detail.
Read on for the answer.