Raven DB to SQL server (NoSQL DB to Relational DB)

Question

Is there a way to convert/migrate NoSQL database data(Raven,Mongo,Couch ) into SQL server data? Since some NoSQL databases lack reporting tools, would be easier if I could move the data to SQL and work off that directly (just for data analysis, querying, reporting needs).Comments appreciated.

You're right, this is the recommended way of doing reporting in RavenDB — Matt Warren, May 18 '11 at 08:41

score 8 · Accepted Answer · answered May 17 '11 at 16:10

8

With Ravendb you have the possibility to replicate an index to a table on a SQL server. See http://ravendb.net/bundles/index-replication

In common you have to 'map' your schema-less data to the database-schema.

answered May 17 '11 at 16:10

ccellar

10,326
2
38
56

1

This might also be of interest; http://ayende.com/blog/4637/ravendb-replicating-to-a-relational-database – Joshua Hayes Aug 05 '11 at 09:54

score 0 · Answer 2 · edited Jan 29 '19 at 21:31

0

Use some exchange format like CSV. Most database systems support CSV export/import through some command line tools. Otherwise you have to write your own migration script.

edited Jan 29 '19 at 21:31

Bernhard

4,855
5
39
70

answered May 17 '11 at 15:07

Raven DB to SQL server (NoSQL DB to Relational DB)

2 Answers2