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-MorganStudio 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 FactorIn 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 FactorWe 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 VargasWith 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 VargasThinking 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 BurgessMongoDB 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 VargasHere’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: 17/04/2024) by Andreu BastardasSQL 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 FactorLearn 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 FactorLearn how you can paste the output of a SQL Server query straight into a MongoDB collection with Studio 3T.