17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

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.
Presented by Mladen Prajdić at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Mladen_Prajdic.png
    Mladen Prajdić is a SQL Server MVP from Slovenia and a C# and SQL Server developer for over 10 years. He blogs at http://weblogs.sqlteam.com/mladenp. He develops a popular add-in for SSMS, called SSMS Tools Pack (http://www.ssmstoolspack.com/).
    http://weblogs.sqlteam.com/mladenp http://feeds.feedburner.com/mladenp
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.