Working with MongoDB & SQL
Using Hackolade to configure Studio 3T SQL Migrations
Studio 3T has an extensive range of operations it can perform to merge data in a relational schema (and usually SQL) into a document centric schema. For some users, they wish to approach this task using modeling tools such as Hackolade which can assist with the field mappings and leave a documentable pathway and records […]
Posted on: 24/08/2021 (last updated: 09/03/2022) • Dj Walker-Morgan • 4 minutesSQL Migration: MongoDB and SQL, Coexistence Made Easy
In the past five years, the relational ‘big beasts’ such as SQL Server, MySQL, PostgreSQL, and Informix have mostly added JSON as a data transfer medium. This doesn’t just mean that the relational database will import tables, views, or queries in JSON format, but also that it will, if necessary, accept and shred JSON as […]
Posted on: 13/11/2020 (last updated: 15/03/2023) • Phil Factor • 4 minutesMongoDB and SQL Server: Communicating via REST Service
We demonstrate how to set up a simple REST service that you can use to communicate between MongoDB and SQL Server.
Posted on: 28/07/2020 (last updated: 31/08/2021) • Phil Factor • 4 minutes3 Tips for SQL Users New To MongoDB
With the trend of SQL and NoSQL hybrid approaches in mind, here are 3 tips for SQL users new to MongoDB – and how a MongoDB IDE like Studio 3T can help.
Posted on: 14/02/2020 (last updated: 28/04/2025) • Kathryn Vargas • 5 minutes6 Tips for Adding MongoDB to Your Database Architecture
Thinking of adding MongoDB to your database architecture? Here are six tips to help prepare you for your new MongoDB tasks.
Posted on: 20/11/2019 (last updated: 04/08/2021) • Kathryn Vargas • 4 minutesMongoDB to SQL Migration
MongoDB to SQL Migration makes it possible to export single or multiple MongoDB collections to SQL, and configure how fields should map to SQL tables and columns before the export is run.
Posted on: 22/05/2019 (last updated: 16/04/2024) • Kirsty Burgess • 9 minutesHow To Merge Multiple SQL Tables Into One MongoDB Collection
Here’s how you can use Studio 3T’s SQL Migration feature to merge multiple SQL tables during import to create a new MongoDB collection.
Posted on: 21/03/2019 (last updated: 28/04/2025) • Kathryn Vargas • 8 minutesSQL to MongoDB Migration
SQL Migration makes it possible import multiple tables from SQL to a single target collection in MongoDB.
Posted on: 21/03/2019 (last updated: 23/04/2025) • Andreu Bastardas • 15 minutes