Tag: SQL
AMA: Setting an SQL Migration primary key
Posted on: 14/11/2022 by Dj Walker-MorganQ: How do I set the primary key in a Studio 3T Migration from MongoDB to SQL? I want to set my own primary key field name and start it at a specific value. A: You can set your SQL primary key through the Migration Mappings interface. When you do an SQL Migration with Studio […]
Studio 3T SQL Import or Migration? #STUDIO3T_AMA
Posted on: 05/10/2022 by Dj Walker-MorganQ: How do Studio 3T’s SQL Import and SQL Migration to MongoDB differ? TL;DR: Migration lets you reshape your incoming SQL data into MongoDB documents. Import, on the other hand, just brings SQL data in as a “flat” collection. A: Unlike SQL Export and SQL Migration, both Import and Migration work with live SQL databases […]
Studio 3T SQL Export or Migration? #STUDIO3T_AMA
Posted on: 28/09/2022 by Dj Walker-MorganQ: What’s the difference between Studio 3T SQL Export and SQL Migration? TL;DR: Migration lets you reshape your MongoDB documents for immediate consumption by an SQL database. Export, on the other hand, flattens your schema before saving SQL in a file. A: On paper, Export and Migration sound like two very similar things. Tools that […]
How does Studio 3T’s SQL Query work? #Studio3T_AMA
Posted on: 08/09/2021 (last updated: 22/09/2021) by Dj Walker-MorganJust what is it that Studio 3T does that lets you use SQL for querying MongoDB? Find out in the latest Ask Manatees Anything #Studio3T_AMA
Simplifying Data Migrations From Legacy SQL To MongoDB Atlas With Studio 3T And Hackolade
Posted on: 24/08/2021 (last updated: 26/08/2021) by Dj Walker-MorganMigrating data from SQL relational databases to MongoDB Atlas may initially seem to be a straightforward process. Export the data from the relational database, import the tables into MongoDB Atlas, and then start writing queries for it. But the deeper you look, the more it can start to feel like a overwhelming task. Decades of […]
Boosting SQL Performance
Posted on: 18/08/2021 (last updated: 06/09/2021) by Dj Walker-MorganGetting the best performance out of SQL databases makes for a speedier and smoother transition to MongoDB. In this article, learn how Studio 3T’s team boosted SQL migration speeds and more.
Tags
Browse by MongoDB topic
- Connecting to MongoDB
- Database Administration & Security
- Getting Started with MongoDB
- Getting Started with Studio 3T
- Import/Export
- Job Automation & Scheduling
- MongoDB Aggregation Framework
- MongoDB/Studio 3T Workshops
- Performance
- Query & CRUD Operations
- Reference
- Schema
- Studio 3T Licensing
- Support and other resources
- Working with MongoDB & SQL
- Working with MongoDB Atlas