RavenDBReplicating to a relational database

time to read 2 min | 369 words

I just finished implementing a very cool feature for RavenDB, the Index Replication bundle allows you to replicate an index to a relational database.

What does this mean? Well, consider the following document:

var q = new Question
 {
     Title = "How to replicate to SQL Server?",
     Votes = new[]
     {
         new Vote{ Up = true, Comment = "Good!"}, 
         new Vote{ Up = false, Comment = "Nah!"}, 
         new Vote{ Up = true, Comment = "Nice..."}, 
     }
 };

And this index:

from q in docs.Questions
select new 
{
         Title = q.Title, 
         VoteCount = q.Votes.Count
}

With the aid of the Index Replication bundle, that index will be replicated to a relational database, giving us:

image

You can find full documentation for this feature here and the bundle itself is part of RavenDB’s unstable as of build 159.

More posts in "RavenDB" series:

  1. (25 Feb 2022) Domain Modeling and Data Persistency
  2. (07 Feb 2022) Practical Considerations for ACID/MVCC Storage Engines
  3. (21 Nov 2013) The Road to Release
  4. (26 Mar 2012) Self optimizing Ids
  5. (27 Feb 2012) It was the weekend before the wedding…
  6. (17 Feb 2012) Index Boosting
  7. (12 Sep 2011) Multi Maps / Reduce indexes
  8. (24 Apr 2011) Let us write our own JSON Parser, NOT
  9. (17 Apr 2011) Safe by default design – it works!
  10. (29 Sep 2010) Splitting entities across several documents
  11. (22 Sep 2010) Replicating to a relational database
  12. (12 Aug 2010) Includes