3T Software Labs, the independent MongoDB tools company, is expanding its database management functionality, introducing new data migration and modernisation support tools.
With Studio 3T 2021.6, it is now easier to take SQL-compatible data and move that to MongoDB. The new service integrates with Hackolade to make managing data migration easier from multiple databases.
By integrating Hackolade’s powerful cross-platform database data modeling, automated denormalisation technology, and lineage tracking to the Studio 3T migration process, developers can take their existing data models and turn them into mappings that can be used to migrate over, according to the vendor.
After designing the Hackolade data model with the Data Definition Language from their SQL database, developers can then quickly import that same model and complete their configurations effectively and easily.
“Making it easier to migrate from SQL systems to MongoDB helps developers be more productive. With the latest version of Studio 3T, developers can move faster and more securely to MongoDB, knowing exactly how the data is mapped,” said Graham Thomson, CTO and Co-Founder, 3T Software.
Also Read: Dremio Launches The Industry’s First SQL Lakehouse Service
The new version of Studio 3T features new capabilities including:
- SQL Import allows the simple migration of tables into MongoDB collections and is ideal for uncomplicated bulk data transfer.
- SQL Export allows MongoDB queries and aggregations to be exported into a portable SQL format, ready for uploading into SQL databases.
- SQL to MongoDB Migration lets developers create multi-table mappings of data which can be used to create optimal MongoDB documents, remaking data to be better suited to the document-centric environment of MongoDB.
- The MongoDB to SQL Migration tools invert that process enabling the export of MongoDB document data into SQL appropriate tables and columns for reporting, replication or legacy processing.
- SQL to MongoDB migration works with MySQL, SQL Server, PostgreSQL, Oracle, IBM DB2 and Sybase.
Also Read: Compass Launches AI-Powered Video Studio