Recently I came across a client that could not get their Transactional Replication data transfer to complete within a reasonable timeframe. Replication initialisation would work ok but from then on no data changes would make it through to the subscriber database.
Recently I re-created 80+ Transactional Replication publications with Updateable Subscriptions as part of a data centre move.
The Transactional Replication (TR) is still one of my favourite parts of SQL Server, and provides some distinctive advantages over Always On Availability Group (AG) Read Only secondaries. The TR advantages include :