CODEWITHSUNDEEP
mongodbcouchdbravendbdatabasenosql
ZVenue
ZVenue

Reputation: 5027

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

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.

Upvotes: 4

Views: 2804

Answers (2)

user2665694
user2665694

Reputation:

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.

Upvotes: 0

ccellar
ccellar

Reputation: 10344

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.

Upvotes: 8

Related Questions