Working with MongoDB & SQL

Using Hackolade to configure Studio 3T SQL Migrations Tool/Feature Documentation

Posted on: 24/08/2021 (last updated: 09/03/2022) by Dj Walker-Morgan

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 […]

SQL Migration: MongoDB and SQL, Coexistence Made Easy Articles

Posted on: 13/11/2020 (last updated: 15/03/2023) by Phil Factor

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 […]

MongoDB and SQL Server: Communicating via REST Service Tutorials

Posted on: 28/07/2020 (last updated: 31/08/2021) by Phil Factor

We demonstrate how to set up a simple REST service that you can use to communicate between MongoDB and SQL Server.

3 Tips for SQL Users New To MongoDB Articles

Posted on: 14/02/2020 (last updated: 10/08/2021) by Kathryn Vargas

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.

6 Tips for Adding MongoDB to Your Database Architecture Articles

Posted on: 20/11/2019 (last updated: 04/08/2021) by Kathryn Vargas

Thinking of adding MongoDB to your database architecture? Here are six tips to help prepare you for your new MongoDB tasks.

MongoDB to SQL Migration Tool/Feature Documentation

Posted on: 22/05/2019 (last updated: 16/04/2024) by Kirsty Burgess

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.

How To Merge Multiple SQL Tables Into One MongoDB Collection Tutorials

Posted on: 21/03/2019 (last updated: 17/01/2022) by Kathryn Vargas

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.

SQL to MongoDB Migration Tool/Feature Documentation

Posted on: 21/03/2019 (last updated: 13/05/2024) by Andreu Bastardas

SQL Migration makes it possible import multiple tables from SQL to a single target collection in MongoDB.

SQL Server to MongoDB Data Transfer Using Extended JSON Tutorials

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

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

How to Create a MongoDB Collection Directly from SQL Server Tutorials

Posted on: 07/03/2019 (last updated: 25/10/2021) by Phil Factor

Learn how you can paste the output of a SQL Server query straight into a MongoDB collection with Studio 3T.