Export database from SQLite to MongoDB

Question

What's probably the easiest way to migrate a small (< 10MB) database from SQLite to MongoDB using command line interfaces?

From what I've figured out so far it seems I'll have to do table-by-table:

> .output user.csv
> .mode csv
> .header on
> select*from user;
> .quit
> mongoimport --collection user --type csv --headerline --db rebuild user.csv

I've also done this before with a script that traversed an XML dump of an RDBMS and populated the NoSQL DB.

Both of these methods work, but they feel inelegant - surely, there's a better way to do it?

Answer 1

If you can use NPM and node, there's an open-source tool called sqlitemongo that handles this use-case for you in a CLI interface.

Run the following terminal commands

1. sudo npm install --global sqlitemongo

2. sqlitemongo <sqlitepath> <mongo uri> [<mongo database>]