The team behind the Studio 3T GUI and IDE for MongoDB has released a new version that includes a SQL migration tool that can be used to import multiple SQL tables into a single MongoDB collection. The import also lets you map table relationships to JSON.

Studio 3T is a GUI and IDE for MongoDB that aims to make it easier to perform tasks such as query building, data exploration, import/export, and code generation. Studio 3T can be used by teams collaborating on MongoDB admin and development, working in either the GUI's visual query builder, MongoDB queries, or SQL. The new migration feature has been added to the latest release, Studio 3T 2019.2.

SQL Migration means you can import multiple SQL tables to a single MongoDB collection. The tool lets you configure how your SQL tables and relationships should map to a MongoDB collection as part of the import, instead of writing export scripts. Most import options are limited to importing a single SQL table to a MongoDB collection. This new tool also avoids the need for sorting out mapping once imported as you can define the relations as part of the import process. The migration tool also includes a JSON preview that shows you how the target MongoDB documents will look before you begin the import process.

The other improvement to the new release is the ability to automate and schedule SQL import or data synchronization jobs. This has been added via Tasks (which lets you save, load, and run frequent MongoDB jobs on-demand), and a Task Scheduler in the Enterprise version of Studio 3T that lets you schedule tasks to be run on specific days and at specific times. Tasks currently support all types of import (JSON, CSV, SQL, BSON), SQL to MongoDB Migration, and Data Compare & Sync jobs.

More Information

Studio 3T Download

Related Articles

MongoDB Updates Charts Tool 

Amazon Ditches MongoDB, Launches Rival

MongoDB 4 Released

MongoDB 4.0 Gets Multi-Doc ACID Support

MongoDB Stitch Makes App Development Easier

MongoDB 3.2 Released 

MonggoDB 3 Announced

MongoDB 2.6 Released

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Comments

Make a Comment or View Existing Comments Using Disqus

or email your comment to: comments@i-programmer.info