RavenDB 2.1 Features: Robust SQL Replication
We had the ability to replicate things to SQL for a long while. But I was never really happy with the implementation. It was awkward, hard to use/configure/setup and didn’t really give us a lot of options in general.
After we finished working on 2.0, I had some free time and used that to create the new SQL Replication bundle, which is much nicer.
Basically, we go from this guy:
To those guys:
And the fun part is that we no longer require to do this using indexing, or have to worry about connectivity issues. RavenDB will automatically handle disruptions in connectivity, and would heal rifts automatically.
But probably the best part is that this is how we define the transformation function between RavenDB and your RDBMS of choice: