I am concerned wether the updates in my dev db pushed to my prod after seeing data I thought was seeded missing. The Planning mode seemed unclear if it could actually see prod, is there a quick way to compare the two dbs aside from manually viewing with db tool?
Hi,
Based on what you’ve described, I’m making a couple of assumptions, so I might be slightly off.
• Replit keeps Development and Production databases separate.
• When you redeploy, schema changes (new tables, new columns) can be applied to Production, but data entered in Development does not get copied into Production automatically.
• First publish
i. If you tick the option to create the Production DB from Development, that’s effectively a one-time data copy at the point of first publish.
• After that
i. Adding or editing rows in the Dev DB later (for example changing Qty from 10 to 5) will not update the Prod DB on redeploy.
ii. Production data only changes if you change it in Production, either via the live app, or by manually editing the Production database in Replit.
• If you’re still testing and do not care about keeping Production data
i. Unpublish, delete the Production DB, then publish again and select Create Production database from Dev.
• Important warning
i. If you delete the Production DB you will lose any Production data you entered.
• If you only need to copy some data across
i. You can switch to the Production DB view and manually add or paste records, but only do this if you’re comfortable working directly in the database.
ii. For anything larger or repeatable, an export/import or a one-off seed script is usually safer than manual edits.