Migrate a whole database
Every collection becomes a table in one run.
- Database and collection names map to schema and table names
- Start here when the SQL Server schema does not exist yet
One-click data migration tool for MongoDB to SQL Server. GUI & CLI supported, cross-platform, 100% local & secure.
A MongoDB database has no schema, so the work is deciding what each collection becomes: one table, many tables, or one table fed by many collections. Eight operations, one dialog.
What arrives in SQL Server is a table, not a linked server: no ongoing connection to MongoDB is created, so the target is queryable by anything that speaks T-SQL. Re-run the session when the source changes, or schedule it — the same mapping is reused.
Every collection becomes a table in one run.
One collection in, one SQL Server table out.
nvarchar(max) columnFilter on the MongoDB side, then insert.
find() filter — or an aggregation — defines the rowsCollections that share a shape add up to one table.
Many collections, one pass.
Field by field, decided once.
ObjectId → text, Date → timestamptzjsonb; Decimal128 → numericRe-run the session instead of re-importing.
_id is the usual one)Run it on a timer.
.bat or .sh| MongoDB (BSON) | SQL Server |
|---|---|
String | nvarchar(450) / nvarchar(max) |
ObjectId | nvarchar(36) or uniqueidentifier |
Int32 / Int64 | int / bigint |
Double | float |
Decimal128 | decimal(38,10) |
Boolean | bit |
Date | datetime2(7) |
Nested document | nvarchar(max) holding JSON |
Array | nvarchar(max) holding JSON |
BinData | varbinary(max) |
ObjectId has no T-SQL type of its own: nvarchar(36) and uniqueidentifier sort differently, so pick the one the target application will query.nvarchar(max) — MongoDB allows a string and a number in the same field, T-SQL does not.nvarchar(max) or varbinary(max) value is capped at 2 GB, so an oversized document fails at the target, not at the source._id uniqueness are not carried over as constraints: the rows arrive, the rules do not.Save your migration session in GUI first (config auto-generated).
Run via Command LineSupports MongoDB 4.2 ~ 8.0+.
Supports SQL Server 2008 R2 through 2022, plus Azure SQL Database.
Free trial supports up to 1000 rows. All features are fully unlocked.
Check network, port, URI, account and whitelist settings.
Yes. Use CLI + scheduled tasks to achieve real-time sync.
Auto-adapt most types. ObjectId can be mapped to VARCHAR manually.
Fast, secure, easy-to-use, cross-platform. No technical skills required.
Free Download Now