Is database migration as scary as it sounds? Amy Tom talks to Matt Groves, Senior Product Marketing Manager at Couchbase, and Curt Gratz, Co-Owner of CKH Consulting. Amy, Matt, and Curt talk about migrating from a SQL database to a NoSQL database, the challenges developers face when shit hits the fan, and assessing the use case of your database. Curt is a Couchbase user and is well-versed in database migration; he shares how to avoid disaster migration and what he's learned using a NoSQL database. Matt slams down the expert advice on what "NoSQL" encompasses, and how to convert your data structures.
In this episode, Amy, Matt, and Curt discuss:
- What considerations are behind the decision between using a SQL database over a NoSQL database? (05:05)
- When is NoSQL an inappropriate solution? Matt says it depends on the amount of data and your need for adaptation/personalization (06:42)
- What are the challenges facing developers moving from SQL to NoSQL? (08:48)
- What the heck is ETL? Curt explains that "ETL-ing data" means transforming your data from one place to another (10:10)
- Can we automatically convert the contents of a SQL Server database to a NoSQL database? Matt talks about his automatic translation project that lifts and shifts data into Couchbase (11:30)
- What data structures need to be converted when migrating from SQL to NoSQL? (13:12)
- If NoSQL is schema-less, do the schemas also migrate over? Long story short, Matt says to think of NoSQL as "schema flexible" instead of "schema-less" (15:57)
- What's the deal with stored procedures and how does that impact NoSQL database operations? (17:30)
- What about ACID and atomic operations when migrating to NoSQL? (20:46)
- What happens when shit hits the fan in the migration process? Can you lose your whole database? Curt talks about disaster migration scenarios and how to solve them (23:07)
- What about the process of migrating from one NoSQL database to another? (29:05)
- What is Curt and Matt's advice to first-time migrators? Curt says to ask yourself, "why am I migrating?", and Matt says to expect things to go wrong (30:52)
Follow Matt Groves & Curt Gratz*:*
- You can follow Matt on Twitter @mgroves
- You can email Matt at matthew.groves@couchbase.com
- You can follow Curt on Twitter @gratzc
- You can email Curt at gratzc@compknowhow.com
Shownotes:
- You can check out Matt's SQL Server To Couchbase on GitHub
- You can learn more about CKH Consulting: https://ckhconsulting.com