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.

Headline feature

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.

Mappings and Previews in MongoDB to SQL Migration

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).

Click on Mappings to configure fields to SQL tables and rows
With Mappings, you can configure how MongoDB fields should map to SQL tables and columns

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 Table Preview displays the real-time preview of your configuration changes
SQL Table Preview shows a real-time preview of your SQL table(s) as you make changes to the mappings
SQL Statement Preview displays a preview of all the SQL statements to be used for the export
SQL Statement Preview displays a list of all the SQL statements written for the export

SQL Migration is an Enterprise feature which supports the popular SQL databases: MySQL, SQL Server, PostgreSQL, and Oracle.

Improvements

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.

Query History in action, in Aggregation Editor

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.

Open an Aggregation Editor tab directly from SQL Query

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.

Group MongoDB connections (e.g. Staging, Production) in Connection Manager
Group MongoDB connections into folders (e.g. Production, Staging)

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:

Leave a Comment

Your email address will not be published.

You may use these HTML tags and attributes: <a href=""> <abbr> <acronym> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>