What database does Okommerce use and how is it provisioned (schema script vs auto-migrate)?

Okommerce uses Microsoft SQL Server (2022) via Entity Framework Core 9. Schema is provisioned by running database scripts so the structure exists before the application queries it. Each new capability ships with an idempotent schema script (safe to run more than once — it checks for tables/columns and only creates what's missing), which is the pattern used when adding features like…

Okommerce uses Microsoft SQL Server (2022) via Entity Framework Core 9. Schema is provisioned by running database scripts so the structure exists before the application queries it. Each new capability ships with an idempotent schema script (safe to run more than once — it checks for tables/columns and only creates what's missing), which is the pattern used when adding features like product variants or recommendations. The practical rule for operators: run the provided schema script(s) against your database before starting the app, so queries against new tables/columns succeed. *(Adopting EF migrations as a baseline is a recommended future improvement for fully automated schema management.)*