Use-case recommendation

Best Format for Database Seed Rehearsal

SQL is the default for database seed rehearsal because it preserves ordered execution and rollback semantics.

Recommendation

Recommendation

SQL

SQL lets you test the same DDL, seed, and transactional behavior that production-like setup jobs actually rely on.

application/sql

CSV

Use CSV when the system under test only supports loader-based tabular imports.

Arquivos: 22

JSON

Use JSON when the workload is closer to API-shaped data than relational replay.

Arquivos: 22

Related decisions

Related Decisions

FAQ

FAQ

Qual e a recomendacao de formato padrao para este caso de uso?

SQL e o formato recomendado por padrao aqui.

Como as equipes devem validar esta recomendacao?

Use arquivos de amostra e endpoints de manifesto para testar compatibilidade e comportamento antes do rollout.