Migrating from SQL to NoSQL with .NET and Dapper

on YouTube ↗01h 11m

" summary

A .NET utility (github.com/mgroves/SqlServerToCouchbase) reads AdventureWorks via Dapper buffered=false streaming, creates Couchbase artifacts (creates buckets scopes collections), serializes rows to JSON and writes with upsert per document, copies some indexes (demo copies ~5 of 100+), and attempts to map users and queries. It handles SQLServer types like geography, skips temporal/history tables and sprocs, and reports similar sanity-check latency (~70 ms under 250 clients) while noting manual work for constraints and complex logic.

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 2:56SQL-to-Couchbase dictionary
3. 11:35Step 0: Connect to database
4. 14:03Step 1: Create bucket
5. 17:11Step 2: Scopes and collections
6. 21:38Step 3: Copy data
7. 27:43Step 4: Copy indexes
8. 31:29Step 5: Copy users
9. 33:07Step 6: Application
10. 38:58Demo
11. 52:30What can't be automated yet
12. 56:00Should I automate this process?
13. 1:01:56What's next?
14. 1:03:10Q&A

" related talks

• 54mBetter Object Mapping in .NET with DapperKevin Griffin · JetBrains .NET Days Online 2020
• 54mSay Yes to NoSQL for the .NET SQL DeveloperJeremy Likness · TechBash 2018
• 01h 01mFrom SQL to Azure Cosmos DBJimmy Bogard · NDC Minnesota 2018
• 01h 02mZero to Document HeroLuce Carter · NDC Oslo 2021
• 01h 02mFrom SQL to Azure Cosmos DBJimmy Bogard · NDC Oslo 2018
• 35mA Customer’s Journey: Migrating from NoSQL to a Cloud Native Distributed SQL DatabaseSRIRAM SITARAMAN · Distributed SQL Summit Asia 2022
• 45mDemystifying NoSQL: The SQL developer's guideMatthew Groves · All Things Open 2020
• 14mUse EF Core to transition from SQL Server to Azure Cosmos DBArthur Vickers · Azure Cosmos DB Conf 2024