Tag: migration

Studio 3T logo

AMA: Setting an SQL Migration primary key

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

Posted on: 14/11/2022 • Dj Walker-Morgan 2 minutes
Studio 3T logo

Studio 3T SQL Import or Migration? #STUDIO3T_AMA

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

Posted on: 05/10/2022 • Dj Walker-Morgan 3 minutes
Studio 3T logo

Studio 3T SQL Export or Migration? #STUDIO3T_AMA

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

Posted on: 28/09/2022 • Dj Walker-Morgan 3 minutes
3T - MongoDB Tools

Simplifying Data Migrations From Legacy SQL To MongoDB Atlas With Studio 3T And Hackolade

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

Posted on: 24/08/2021 (last updated: 26/08/2021) • Dj Walker-Morgan 4 minutes