Skip to main content

MSSQL

Bitwarden primarily stores data in MSSQL (Microsoft SQL Server). The data access layer in the Server is written using Dapper which is a lightweight object mapper for .NET.

Creating the database​

See Server Setup Guide.

Updating the database​

The dev/migrate.ps1 helper script uses our MsSql Migrator Utility to run migrations. You should run the helper script whenever you sync with the main branch or create a new migration script. Migrations that have already been run are tracked in the Migration table of your database.

If you run the server with Aspire, the run-db-migrations resource runs this script every time the AppHost starts. To apply new migrations without restarting the AppHost, restart run-db-migrations from the Aspire dashboard.

Modifying the database​

The process for modifying the database is described in Migrations.