Tag: migration
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 […]
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 […]
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