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


EG: A Tool For API Snippets
25/11/2020

As programmer's our modis operandi is to use existing APIs and turn them to novel uses. In order to do this we rely on good examples of how APIs are used. This is where EG, a tool that mines codebases [ ... ]



.NET For Apache Spark Updated
05/11/2020

The .NET bindings for Spark have been updated. The new 1.0 version adds support for .NET apps targeting .NET Standard 2.0 or later, as well as support for Apache Spark DataFrame APIs.


More News

square

 



 

Comments




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

Last Updated ( Tuesday, 09 April 2019 )