Migration Makes My Skin Crawl: From SQL to NoSQL

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 [email protected] You can follow Curt on Twitter @gratzc You can email Curt at [email protected] Shownotes: You can check out Matt's SQL Server To Couchbase on GitHub You can learn more about CKH Consulting: https://ckhconsulting.com