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.
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!