Studio3T MongoDB GUI Adds Migration
Written by Kay Ewbank   
Tuesday, 09 April 2019

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.

studio3t

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.

json preview sql migration

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.

studio3t 

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.

Banner


Machine Learning For Cat Control
06/07/2019

This may not be the cat video you were expecting, but after numerous articles on computer vision recognizing cats, here's one in which machine learning is put to work to detect when your cat is bringi [ ... ]



Apple Removes Apps At Government Request
10/07/2019

Although Apple is often seen as being a law unto itself, it also has to comply with the legal restrictions imposed in the different countries in which it operates. The newly published Apple Transparen [ ... ]


More News

appC

 



 

Comments




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

Last Updated ( Tuesday, 09 April 2019 )