My app has a bunch of default data we’ve been creating in the test env that I need to “seed” as part of going live.
For example, users choose from a default set of Categories and take an associated survey. I need to ensure all the default Categories and Questions (hundreds) we’ve built are pre-populated with values. Of note, some of the default data types I want to seed in the Live db have custom fields which are Lists of Things, so I’m a bit gunshy about importing seed data via CSV post-deploy (mess up one comma in the List’s values on CSV import and the live database will be royally messed).
What’s best practice here? I’m thinking 2 options:
-
Use Copy and Restore during initial deploy, and just push all the data from test --> live.
Pros: Easy
Cons: All the test data–not just the necessary seed data fields–including lots of junk users and data, clutters up Live db on day 1. -
Standard deploy, then use Import CSV to populate just the seed data stuff.
Pros: Cleaner Live db on day 1
Cons: Mistake prone if CSV mapping/import has errors. Easy to back out, but don’t relish a lot of trial and error.
Appreciate any tips and best practices from the grizzled Bubble vets!