Re: convert Mongo JSON

Posted by ErmanArslansOracleBlog on Oct 12, 2020; 1:58pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/convert-Mongo-JSON-tp8857p8858.html

I never used this kind of a tool, but there are some tools for migrating data from mongodb to rdbms databases.

I made a quick search and found this one -> SQLizer.

But I never used it before.

Check these ->

https://blog.sqlizer.io/posts/mongodb-sqlizer-api/
https://sqlizer.io/?utm_source=mongodb#/

They say -> Upload your Excel file, choose the worksheet with the data, select the cell range, and hit convert. We'll convert your file into a MySQL script with a table definition and multiple INSERT statement..

So these insert statements are actually what you are looking for but uploading data to a website? Hmm that's a little weird.

You can write your own script to create those inserts for you!.
So, write a program that reads the records from MongoDB and transforms them into the equivalent then create insert statement according to your target rdbms..

So if you are asking for Oracle;

For data tansfer, you may follow an approach like this as well->

Use mongoexport nd export to a csv. Then use tools like SQLLoader or write a PL/SQL block to import that data to Oracle.