KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
we are using MongoDB (on Linux) as our main database. However, we need to periodically (e.g. nightly) export some of the collections from Mongo to a MS SQL server to run analytics. I am thinking about the following approach: Backup the Mongo database (probably from a replica) using mongodump Restore the database into a Windows machine where Mongo is istalled Write a custom made app to import the collections from Mongo into SQL (possibly handling any required normalization). Run analytics on the Windows SQL Server installation. Are there any other "tried and true" alternatives? Thanks, Stefano EDIT : for point 4, the analytics is to be run on SQL Server, not Mongo.
Tags (comma-separated)
Save Edits
Cancel