将数据从关系数据库迁移到NoSQL [英] Migrate data from relational DB to NoSQL

问题描述

有可能/有工具/最佳实践等将数据从关系数据库迁移到NoSQL格式。

我有一个使用Hibernate的JEE6应用程序ORM持久到MySQL，但现在我们希望转移到NoSQL解决方案，但需要带来现有的数据

感谢
W

解决方案

有一些工具可以帮助迁移，但最终，MySQL是一个关系数据库，它与noSQL数据库的结构完全不同。 p>

最后，您几乎总是需要执行这篇文章（指的是mongoDB，你没有指定，但它适用于任何）：

1。了解MongoDB。下载它，阅读教程，尝试一些玩具项目。

2。考虑如何在其文档存储中表示模型。 p>

3。将数据从数据库迁移到MongoDB，可能只是写一堆 SELECT * FROM 语句对数据库和
然后使用您选择的语言
将数据加载到您的MongoDB模型中。

4。重写应用程式程式码，透过insert（）或find（）等语句查询MongoDB。

Is it possible/are there tools/ best practices etc to migrate data to a NoSQL format from a relational DB.

I have a JEE6 app making use of Hibernate ORM to persist to MySQL but now we wish to move to NoSQL solution but need to bring the existing data with us

Thanks W

解决方案

There are some tools to help the migration, but in the end, MySQL is a relational database which has a completely different structure from noSQL databases.

In the end, you will almost always have to do these four steps stated in this article (refers to mongoDB, and you didn't specify, but it applies to any):

1. Get to know MongoDB. Download it, read the tutorials, try some toy projects.

2. Think about how to represent your model in its document store.

3. Migrate the data from the database to MongoDB, probably simply by writing a bunch of SELECT * FROM statements against the database and then loading the data into your MongoDB model using the language of your choice.

4. Rewrite your application code to query MongoDB through statements such as insert() or find().

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