http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Tobi, You can certainly do it today using Raven. http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment10http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment10Wed, 22 Sep 2010 13:39:16 GMTMaterialized views can only reference tables, not other materialized views. So you can only get one level deep. It could be very convenient to have nested materialized views to build up more complex structures. I have encountered the need multiple times (I wanted to do two level aggregation and the other time I wanted to express exists queries through joins and groupings over multiple levels). nested materialized views = stacked materialized views. [research.microsoft.com/.../Views-on-Views.pdf](http://research.microsoft.com/en-us/um/people/jrzhou/pub/Views-on-Views.pdf) Also I would have liked to pre-materialize a xml/json document that describes every piece of data needed for a particular url. This is not possible using sql server indexed views but would be quit a killer. Image you could stitch all information required for a whole forum thread (thread-info, posts, users, their reputation and badges, ...) up into one json document by creating a tree of raven indexes that ultimately result in a table with pk (threadid) and a json document containing all required data. this would allow you to write normalized data in sql server (convenient and immune to data anomalies) and read in a document-oriented way from raven (also convenient and very fast). not sure if this is possible today as I believe raven indexes cannot join or build tree structures but I hope you see the use case. Low dev costs and blinding performance. certainly a complex feature set to implement. http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment9http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment9Wed, 22 Sep 2010 13:33:44 GMTTobi, I would be pretty trivial to do the reverse using triggers, but I am not sure what it would give you. What do you mean, stacked materialized views? http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment8http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment8Wed, 22 Sep 2010 13:05:59 GMTAnother idea would be to replicate from sql server to ravendb as a means of having stacked materialized views (which sql server does not support yet). You can implement this in a number of different (complex) ways: CDC, replication infrastructure, triggers, change notification/sqldependency class. I was proposing xml fields as a means of making sql server behave more like a document storage. I am sure there are cases where the performance benefit justifies the complexity. http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment7http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment7Wed, 22 Sep 2010 12:40:08 GMTTobi, Xml fields in SQL Server are... workable, but they don't really work nice with reporting tools. http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment6http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment6Wed, 22 Sep 2010 12:20:00 GMTConfigurator, thanks, I fixed that. http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment5http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment5Wed, 22 Sep 2010 12:17:28 GMTThis is very very useful as it makes it very easy to do mixed data storage with sql server still in use. This will make migration a lot easier too. I think you should advertise this feature a bit to see if it might be a killer one. You could also try to replicate json trees as xml for which sql server has great support. http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment4http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment4Wed, 22 Sep 2010 12:08:16 GMTWhen does the replication happen? - is it triggered with every new document that is added to that index ? - is it on demand (press this button here) ? - is it a timed job ? When I first heard about this i thought "Why would I want my index definition stored in a database?" Now i understand you meant the index result set is replicated into the database. This is a great bundle for teams who have members more comfortable doing reporting with SQL. Thanks. http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment3http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment3Wed, 22 Sep 2010 11:46:25 GMTNice! I'm getting closer and closer to wanting to use RavenDB. :-) http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment2http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment2Wed, 22 Sep 2010 10:35:53 GMTVery cool feature! You have a type in the documentation: "You can directly replicate between a document and a RDBMS table, because the format of a document simply cannot be made to work on a relational database." Should probably be "You can't ..." http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment1http://ayende.com/4637/ravendb-replicating-to-a-relational-database#comment1Wed, 22 Sep 2010 08:44:55 GMT