How to Migrate from SQL to MongoDB: A Practical Playbook
A phased playbook to migrate from SQL to MongoDB: access patterns, document design, ETL, sync, validation, cutover and rollback planning.
Category
MongoDB
MongoDB is a document database that stores data as flexible, JSON-like BSON documents instead of rows in fixed tables. It supports rich queries, secondary indexes, an aggregation pipeline and multi-document transactions, and scales out through replica sets and sharding. It fits applications with changing or nested data, such as content platforms, product catalogues and event logs, and runs self-hosted or as the managed Atlas service.
13 articles
-
-
MongoDB Backup and Restore: mongodump, mongorestore, and What to Test
Back up MongoDB with mongodump, snapshots or managed backup, restore with mongorestore and oplog replay, and test restores…
-
MongoDB with Node.js: Mongoose vs the Native Driver
Mongoose 5 vs the MongoDB Node.js driver 3: schemas, validation, middleware, populate, lean queries, transactions, and how to…
-
MongoDB Security Best Practices: Authentication, Authorization, and Network Isolation
Secure MongoDB: enable SCRAM authentication, least privilege roles, bindIp and network isolation, TLS, encryption at rest and auditing.
-
MongoDB Sharding: When You Actually Need It and How to Choose a Shard Key
When MongoDB sharding is really needed, how clusters work, and how to choose a shard key: cardinality, frequency,…
-
MongoDB Replica Sets Explained: High Availability Without the Complexity
How MongoDB replica sets work: members, elections, oplog, write and read concern, read preference, retryable writes and rolling…
-
How to Read MongoDB explain() Output and Find Slow Queries
Read MongoDB explain() output, compare keys and docs examined, use the profiler and slow query log, and fix…
-
MongoDB Aggregation Pipeline Tutorial: $match, $group, and $lookup
Build MongoDB aggregation pipelines with $match, $group, $unwind, $lookup, $facet and $merge, with worked reports and performance rules.
-
InsertMany in MongoDB via file
while studying for mongoDb certification I got a dataset file from the instructor. I had to fill my…
-
MongoDB Indexing Tutorial: Types, Creation, and When to Use Each
MongoDB index types explained: compound with the ESR rule, multikey, text, geo, hashed, wildcard, partial and TTL, plus…
-
MongoDB Schema Design: Embedding vs Referencing (and When to Choose)
When to embed and when to reference in MongoDB, with cardinality rules, subset, bucket and extended reference patterns,…
-
MongoDB CRUD Tutorial: Insert, Find, Update, and Delete Documents
Learn MongoDB CRUD in the shell and Node.js: insertOne, find with operators, update operators, upserts, deletes, bulkWrite and…
-
What Is MongoDB? Documents, Collections, and How It Differs from SQL
What MongoDB is: documents, BSON, collections and databases, how they map to SQL tables and rows, and when…
