如何将数据从MongoDB迁移到SQL-Server? [英] How to migrate data from MongoDB to SQL-Server?

问题描述

我四处搜索，发现有几种方法可以将数据从sql-server传输/同步到mongodb.

我还知道Mongodb包含集合而不是表，并且数据存储方式不同.

我想知道是否有可能将数据从mongodb移动到sql-server.如果是，那么我应该如何以及使用什么工具/主题?

解决方案

当然可以，但是您将需要找到一种将MongoDB这样的文档数据库的灵活性强加到SQL Server这样的RDBMS中的方法.

这意味着您需要定义如何处理丢失的字段(在db列中为NULL?还是默认值?)以及通常不适合关系数据库的其他内容./p>

说，您可以使用能够连接到两个数据库的ETL工具，如果您想留在MicroSoft的世界中，可以使用SSIS作为示例(您可以查看此Talend大数据集成，它具有与MongoDB(当然还有SQL Server)的连接器.

I searched around I found that there are ways to transfer/sync data from sql-server to mongodb.

I also know that Mongodb contains collections instead of table and the data is stored differently.

I want to know whether it is possible to move data from mongodb to sql-server. If yes, then how and what are the tools/topics should I use?

解决方案

Of course it's possible, but you will need to find a way to force the flexibility of a document db like MongoDB into a RDBMS like SQL Server.

It means that you need to define how you want to handle missing fields (will it be a NULL in the db column? or a default value?) and other things that usually don't fit well in a relational database.

Said do, you can use an ETL tool able to connect to both databases, SSIS can be an example if you want to stay in the MicroSoft world (you can check this Importing MongoDB Data Using SSIS 2012 to have an idea) or you can go for an open source tool like Talend Big Data Integration which has a connector to MongoDB (and of course to SQL Server).

这篇关于如何将数据从MongoDB迁移到SQL-Server?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！