Import from dev to prod failing with _id ... cannot be imported into 'users' error
Hey team, I’m trying to import data from my dev deployment into prod using the following command:
_id jx72anbqkxyayav4yhj2j79q0n7sqwst cannot be imported into 'users' because it came from a different deployment and conflicts with preexisting tables in this deployment.
Try deleting preexisting tables or importing into an empty deployment.
I can’t delete or replace the users table since it’s linked to existing prod data.
Is there any way to merge data from dev → prod without replacing or manually editing IDs?
Here’s what I’ve tried so far:
Exported from dev using npx convex export --path ./snapshot.zip
Imported into prod using --append
Still fails on the users table due to conflicting _ids
CONVEX_DEPLOY_KEY='prod:xxxx|eyJ2MiI6IjY5NDk2YWY4ZTY1NTQzYzBiMzVi' npx convex import --prod --append ./snapshot.zip -yCONVEX_DEPLOY_KEY='prod:xxxx|eyJ2MiI6IjY5NDk2YWY4ZTY1NTQzYzBiMzVi' npx convex import --prod --append ./snapshot.zip -y_id jx72anbqkxyayav4yhj2j79q0n7sqwst cannot be imported into 'users' because it came from a different deployment and conflicts with preexisting tables in this deployment.
Try deleting preexisting tables or importing into an empty deployment.
I can’t delete or replace the users table since it’s linked to existing prod data.
Is there any way to merge data from dev → prod without replacing or manually editing IDs?
Here’s what I’ve tried so far:
Exported from dev using npx convex export --path ./snapshot.zip
Imported into prod using --append
Still fails on the users table due to conflicting _ids
