Hello, I’ve finished testing my automations in the sandbox and have deployed the changes to production. Everything is working correctly, but I would now like to sync my test data from the sandbox to production. What is the best way to do this?
Question
SANDBOX DATA SYNC
+32Not very elegant, but I ended up exporting the data as a CSV and then reimporting it. Hopefully someone else has a better idea!
+6+1 to
You have to move the data manually, export data as a CSV and then import it into production…
BUT, Important considerations :
- Record IDs will NOT transfer, avoid relying on them
- Linked records : migrate parent tables first, then children
- Attachments : usually carry over, but double check
- Automations : make sure they don’t accidentally trigger during import
CSV export/import is pretty much the default here, so you’re not missing anything. If you've created or modified records in sandbox and need them in production, your options are:
- CSV export/import - quickest, native method, but you'll lose things like attachments, linked records, record IDs, and other complex field types may not transfer cleanly. It can get messy real quick.
- Airtable API - More precise and handles more field types, but requires development effort so it can be more work to get it setup.
We go case by case and decide if speed or control is more important. All comes down to how much data you’re moving sometimes.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.