What’s New in Studio 3T 2019.3 | MongoDB to SQL Migration, Query History & More
Data migration comes full circle in Studio 3T 2019.3.
In our newest release, we’ve added MongoDB to SQL export functionality to SQL Migration, so now you can also export your MongoDB collections directly to a SQL database or file.
And to save you even more time, you can automate all migrations through Tasks.
SQL Migration | MongoDB to SQL Migration
The last release brought you SQL to MongoDB Migration. In this release, we’re completing the data round-trip by adding MongoDB to SQL Migration, making data migration seamless, both ways.
With the same ease as importing SQL to MongoDB, you can now take your MongoDB collections and export them to a SQL database or file, and configure how JSON should map to SQL before the export.
Perfect for SQL and MongoDB round-tripping
If you work with both SQL and MongoDB, the now bi-directional SQL Migration lets you effortlessly move data between the two databases.
You can save a whole lot of time (and data clean-up) by making use of Mappings, where you can configure exactly how data from the source database to should be mapped to the other (e.g. SQL to JSON and vice versa).
There’s also the many available Previews, so you can always ensure your configuration is correct as you add/remove fields, change data types, define relationships, before running the import or export.
SQL Migration is an Enterprise feature which supports the popular SQL databases: MySQL, SQL Server, PostgreSQL, and Oracle.
Query History, everywhere
In addition to Visual Query Builder, you can now view your query history in Aggregation Editor, IntelliShell, and SQL Query.
No matter where you are in Studio 3T, you’ll be able to find your previous queries, load them, and run them as you need.
SQL Query | One-click copy to Aggregation Editor
Instead of copying mongo shell code to the clipboard and pasting it manually into Aggregation Editor, you can now open an Aggregation Editor tab – with the mongo shell code already pasted – directly from SQL Query with the click of a button.
Connection Manager | Group your connections
Add connections to a group in either Connection Manager or SQL Connection Manager by drag and drop, or by defining the group directly in the Edit Connection dialog.
Collapsible Global Toolbar | More space for your data
Now with a collapsible Global Toolbar, you can create more space for slicing and dicing your data. Simply go to View > Show/Hide Global Toolbar.
SQL to MongoDB Migration | Views, flipped
Not to be left out, SQL to MongoDB Migration also gets some improvements in this release. We’ve flipped our Schema and Datasets View and made other small changes for a better migration experience.
…and much more:
- SQL Query | regex support added
- Visual Query Builder | Find, project, sort selection now toggleable
View the full list of changes and updates in our changelog.
Download Studio 3T
Upgrade to the latest Studio 3T version, or start your free 30-day trial today: