Convert SQLite to MongoDB

Asked Jul 02 '20 at 17:12

Active Jul 02 '20 at 17:40

Viewed 110 times

I have a normalized SQLite database and I want to convert to one collection MongoDB database. let's take an example:

We suppose that my SQLite database looks like : SQLite database tables

I want my MongoDB database looks like :

{
   "_id" : ObjectId("5efdf2c2b268674c2bf74e85"),
   "firstName": "robert",
   "lastName": "kas", 
   "addresses":[
               {
               "address": "This is address 1",
               "type": "home",
               },
               {
               "address": "This is address 2",
               "type": "work",
               }
              ]
}

edited Jul 02 '20 at 17:40

AlBlue

20,872
14
63
85

asked Jul 02 '20 at 17:12

B. Sofiane

Any preference which tool you like to use? – Wernfried Domscheit Jul 02 '20 at 17:16
using tools in what? – B. Sofiane Jul 02 '20 at 17:22
Which tool (or programming language) you like to use to make the migration? – Wernfried Domscheit Jul 02 '20 at 17:24
currently, I'm learning node.js, but I feel more comfortable with java – B. Sofiane Jul 02 '20 at 17:26
Then do it in Java. Look how to select data from SQLite, read it row by row and write it to Mongo. I don't think there is any tool where your could do it with a single command. – Wernfried Domscheit Jul 02 '20 at 17:28
When you have code samples, highlight the text and click {} in the toolbar, or put 4 spaces in front of each line. That way it will show up in preforrmatted text. – AlBlue Jul 02 '20 at 17:41
You can try one of the options in the following post to get JSON from the sqlite database tables. Then you can import the JSON into MongoDB and build your collection: [Convert SQLite to JSON](https://stackoverflow.com/questions/25722585/convert-sqlite-to-json). – prasad_ Jul 03 '20 at 01:51

Convert SQLite to MongoDB

0 Answers0