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 minutes

SQL 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 minutes

MongoDB 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 minutes

3 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: 10/08/2021) • Kathryn Vargas • 5 minutes

6 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 minutes

MongoDB 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 minutes

How 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: 17/01/2022) • Kathryn Vargas • 8 minutes

SQL 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: 13/05/2024) • Andreu Bastardas • 15 minutes

SQL Server to MongoDB Data Transfer Using Extended JSON

Learn how to transfer databases from SQL Server to MongoDB (and vice versa) using Extended JSON.

Posted on: 07/03/2019 (last updated: 04/08/2021) • Phil Factor • 7 minutes