Lacuna PSC command: update-db
Name
update-db - Updates the database model
Syntax
dotnet Lacuna.Psc.Site.dll [settings] -- update-db
Or, on Docker:
docker run -i lacunasoftware/psc:1.2 [settings] -- update-db
The settings arguments are additional settings to overwrite settings from configuration files and environment variables,
for instance --Section1:Name1=value1 --Section2:Name2=value2.
Description
The update-db command updates the database model by applying a series of migrations. It is meant to be used only when
running Lacuna PSC without db_owner privileges.
Since in this scenario Lacuna PSC's database credentials do not grant permissions to change the database model, you typically will want to run this command passing a privileged connection string:
dotnet Lacuna.Psc.Site.dll --ConnectionStrings:DefaultConnection="Data Source=SERVER;Initial Catalog=DATABASE;User ID=USERNAME;Password=PASSWORD" -- update-db
Tip
On Linux, if your password contains the ! character, use single quotes instead, e.g. --ConnectionStrings:DefaultConnection='...', to avoid
shell history expansions