Migration oracle database to mongo db
bibhu patnaik
Stephen Steneker
Hi Bibhu,
You’ve started multiple discussions with the same questions:
Can you please allow time for someone to respond on an original thread rather than reposting duplicates?
To answer the general gist of your questions: MongoDB and Oracle are inherently different database products and you should not be thinking about migrating data & indexes in your existing relational pattern as-is into MongoDB. For the best outcome in planning your migration, I would recommend spending more time learning about MongoDB or engaging a consultant.
For your specific questions:
1. Can we Migrate all the tables for example 3 tables are there in a oracle database and 2 tables having child tables as well in this scenario can we migrate exactly in same pattern into mongodb?
An effective data model in MongoDB will be designed to support your use case. Please review the Data Models section of the MongoDB documentation for more background on data model concepts, patterns, and related presentation/blog resources. The SQL to MongoDB Mapping Chart should also be useful for comparative terminology.
2. can we migrate indexes of above 3 oracle tables into Mongodb in exactly in same manner as it was in oracle?
It is likely that you will design a different data model (and as a result, different indexes) for MongoDB. There are also some differences in the types of indexes available. For more information, please review the Indexes section of the MongoDB manual.
3. any thing is there in Mongodb related to procedure, function in oracle?
MongoDB (as at 3.2) does not provide the equivalent of stored procedures or arbitrary server-side functions. For server-side data processing, there are several options for aggregation. You may find the SQL to Aggregation Mapping Chart helpful.
4. How to run a script in Mongodb?
5. How to import multiple tables into mongodb at once.
There are several approaches depending on the source and format of your data. For text data (JSON or CSV) MongoDB includes mongoimport/mongoexport command line tools. For dumping/restoring data from MongoDB in the native BSON format you can use the mongodump/mongorestore tools. See: Back Up and Restore with MongoDB Tools.
If you want to load data directly from Oracle into MongoDB you can write a custom script in your favorite application language, or look for a third party data migration / ETL tool.
Other helpful resources for learning about MongoDB:
- Take one of the free courses at MongoDB University (eg. M102 for DBAs)
- Review the MongoDB manual for features & tutorials
- Frequently Asked Questions
Regards,
Stephen