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.

Let’s take a look at how easy it is to safely export your MongoDB data 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

This superb feature is only available in our upgraded Studio 3T packages: Pro and Enterprise. Learn more about the benefits before you purchase by contacting our dedicated team at sales@3t.io.