Custom Replication w/ Service Broker and Change Data Capture
For some scenarios built in replication just isn't enough.
What if you had to securely move and map data from 5 tables to 3 tables in different databases over multiple servers not even in the same domain?
In this session will take a look at how to build this kind of replication using the Service Broker and Change Data Capture or Change Tracking. With Service Broker offering guaranteed async ordered message delivery and Change Data Capture giving us the changes in our tables we can build a flexible publishing framework between various databases and machines.
But of course it's not all unicorns and rainbows so we'll look at some of the downsides too.