Guide families Confronti tra formati Guide al formato migliore Miglior formato per Guide alla conversione
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.

Open Samples Open Manifest
Recommendation

Recommendation

SQL

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

application/sql

Open Samples Open Hub

CSV

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

Files: 22

Samples Hub

JSON

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

Files: 22

Samples Hub
Related decisions

Related Decisions

SQL vs CSV CSV vs JSON Miglior formato dati per le API How to Convert ACCESSLOG to JSON
FAQ

FAQ

What is the default format recommendation for this use case?

SQL is the recommended default format here.

How should teams validate this recommendation?

Use sample files and manifest endpoints to test compatibility and behavior before rollout.