A Node.js script to convert an SQL database to a MongoDB database.
If you like this project, please star this repo and support my work
Features
- Automatically detects the primary key for each SQL table and copys it to the MongoDB _id field.
- Optionally remaps replaces and primary keys with MongoDB ObjectId's and remaps foreign keys.
- Automatically copies across types correctly (eg numbers and dates).
First install dependencies:
npm install
Edit config.js. Add the connection string for your SQL database. Modify the MongoDB connection string if necessary. Set the name of your target database in MongoDB.
node index.js
It might take some time to replicate!
Find more like this in my new book Data Wrangling with JavaScript