One of the most popular features in Studio 3T is the Export to SQL feature. This is a premium feature and thus available only in the Pro and Enterprise editions of Studio 3T.

MongoChef is now Studio 3T. Learn more HERE!

Let’s take a look at how easy it is to safely export MongoDB to SQL.

Let our Export Wizard do the heavy lifting for you in deciding what data you want to export.

Export MongoDB to SQL - Select source of Export

Choose the export format.

Export MongoDB to SQL - Select export format

We of course support all the major SQL databases for your convenience: Oracle, MS SQL Server, MySQL, and PostgreSQL. Name your SQL table, choose whether you want to add statements for Create or Drop Table. You can also choose to use an auto-incremented, additional column as a primary key.

Name your SQL table, choose whether you want to add statements for Create or Drop Table. You can also choose to use and auto-incremented, additional column as a primary key.

Export MongoDB to SQL - Select fields to export

Studio 3T matches the Source Type with the closest SQL type, but you can override this. Rename the SQL column too, if you like.

Export MongoDB to SQL - Source and target type mapping

Choose where the data will export to. Or just export to Clipboard.

Export MongoDB to SQL - Target file

A summary of your export lets you see the overall view easily.

Export MongoDB to SQL - Export Summary

Success! Your new SQL file can now be safely imported for quick deployment.

Export MongoDB to SQL - Resulting SQL file

Studio 3T not only makes it easy to export MongoDB to SQL, but we’ve also recently introduced another superb feature in our Studio 3T Pro and Enterprise licenses: SQL querying in MongoDB! Learn more about our Core, Pro, and Enterprise licenses and discover the wealth of useful features Studio 3T has to offer.