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