Export to Sql Server and Excel

[devm...@hotmail.com]

hi, 

is there a way to export the data from Raven to Sql Server and Excel formats ?

thanks in advance.

[Mauro Servienti]

There is the “Index Replication Bundle”

http://ravendb.net/docs/server/bundles/indexreplication

 

.m

[devm...@hotmail.com]

thank you man, 

but does that mean that i have to create Index for each collection ?

[Oren Eini (Ayende Rahien)]

You need a way to convert from the document model to the flat relational model,yes.

[Chris Marisic]

Will RavenDB create the tables it needs for the replication to sql server bundle?

[Oren Eini (Ayende Rahien)]

No, you need to do that

[Chris Marisic]

The bundle would be incredibly more useful if it could do that.

[Kijana Woodard]

I'm guessing the trouble would be figuring out how to layout the tables. For documents with some depth, that would be tricky. For simple cases, maybe the NServiceBus Saga NHibernate code could be a start.

[Oren Eini (Ayende Rahien)]

That would add enormous complexity. What are the data types? Can you create FK for me? How do I customize field names? How can I define a column that won't be used in the transformation but will be used by the code reading the table?

Easier to leave it out of scope, since then users can do whatever they want and have the utmost flexibility.

[devm...@hotmail.com]

thank you Ayende for clarification

[Itamar Syn-Hershko]

Plus it's a one time setup