从Oracle到Mongo DB的数据迁移 [英] Data Migration from Oracle to Mongo DB
问题描述
我目前正在为我的项目进行POC,以查看是否可以从Oracle迁移到MongoDB.我的Oracle结构目前是扁平的(单个表,没有带有几列和CLOB的关系表).
I am currently doing a POC for my project to see if I can migrate to MongoDB from Oracle . My Oracle structure is currently flat ( Single table with no relational tables with a few columns and a CLOB ) .
我有大约10个lac记录,并希望将其迁移到Mongo,以分析我的检索/当前存在的其他查询的性能.
I have about 10 lac records and want to migrate this to Mongo to analyse the performance of my retrievals/ other queries that exist currently .
我可以编写一些自定义脚本将其从Oracle移到Mongo,但是我想知道是否有免费的工具可以帮助我从oracle移动所有行并将其作为json文档存储在mongo中(列名:数据).
I could write some custom script to move this from Oracle to Mongo but i was wondering if there are any free tools out there which could help me move all the rows from oracle and store it as json documents in mongo ( Column name : data ) .
那么有没有什么工具可以帮助我呢?
So are there any tools out there which could help me out ??
P.S:我确实看到过pelica migrator,但是在试用版中它仅支持十个文档:(
P.S : I did see pelica migrator but it supports only ten documents in the trial version :(
谢谢
推荐答案
您是否尝试过"MongoImport"工具?
Have you tried "MongoImport" tool?
这篇关于从Oracle到Mongo DB的数据迁移的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!