RavenDBReplicating to a relational database
time to read 2 min | 368 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.

0 comments
Tags:

Related posts that you may find interesting:

14 Jan 2013 RavenDB 2.1 Features: Robust SQL Replication
raven
17 Oct 2013 The curse of resource utilization
raven
06 Aug 2015 What is new in RavenDB 3.5: Collection Specific Replication
raven

More posts in "RavenDB" series:

  1. (11 Jul 2025) The Gen AI release
  2. (18 Mar 2025) One IO Ring to rule them all
  3. (19 Feb 2025) Clocking at 200 fsync/second
  4. (17 Feb 2025) Shared Journals
  5. (14 Feb 2025) Reclaiming disk space
  6. (12 Feb 2025) Write modes
  7. (10 Feb 2025) Next-Gen Pagers