Export data from a dev deployment: npx convex export --path convex-dev-export.zip Import into a prod deployment: npx convex import --replace-all convex-dev-export.zip --admin-key <key> --url <prod-url> Deploy functions to prod: npx convex deploy Query tables via ConvexHttpClient (the HTTP query API) Expected: All imported tables are queryable via the HTTP query API, same as via CLI.
Actual: Some tables return data, others return empty arrays โ even though the data is confirmed present via npx convex run.
Specifics:
Tables that work via HTTP query API after import: pages, chatSessions, chatProjects, shares, sharedChats Tables that return empty via HTTP query API after import: chatMessages, sharedProjectAccess The same query function (chatMessages:getSessionMessages) returns data when called via npx convex run (admin/CLI API) but returns [] when called via ConvexHttpClient Schema is deployed and matches the imported data Tried npx convex deploy multiple times โ no change The data is visible in the Convex dashboard Workaround attempted: Tried delete-and-reinsert ("rematerialization") to force Convex to re-index the documents, but this wasn't practical at scale.
Impact: We were unable to migrate from dev to prod deployment. Had to revert to sharing a single database between environments.