Currently the database command can be used to upgrade the database to the expected schema.
Code Block | ||||
---|---|---|---|---|
| ||||
Usage: AMANA.SmartTaxBalance.Web.Api.exe database [<options>] Where [<options>] is any of: --upgrade Upgrades the database to the expected schema. --connectionString=VALUE [Optional] Sets the database connection string to use. If omitted, the value from the config file will be used to perform operations anon the database. Or one of the common options: --help Show detailed help for this command --version Show version information |
...
This example performs the database upgrade to the expected schema. It uses the connection string from the configuration.
Code Block | ||||
---|---|---|---|---|
| ||||
AMANA.SmartTaxBalance.Web.Api.exe database --upgrade |
Upgrade database with connection string
This examples example performs the database upgrade to the expected schema with a custom connection string. This is useful, when the connection string from the configuration
Example use cases for custom connection strings:
You can use a custom connection string with enhanced rights if your default connection string does not have sufficient rights to perform
...
a database update.
...
Code Block language text
...
AMANA.SmartTaxBalance.Web.Api.exe database --upgrade --connectionString="Server=(localdb)\MSSqlLocalDb;Database=taxbalance;User ID=sa;Password=sa;Trusted_Connection=True;TrustServerCertificate=True"
You can use a custom connection string with a larger connection timeout if you experience time out issues during a database update at the tax balance start up. The following example sets the command timeout to 300 seconds.
Code Block language text AMANA.SmartTaxBalance.Web.Api.exe database --upgrade --connectionString="Server=(localdb)\MSSqlLocalDb;Database=taxbalance;User ID=sa;Password=sa;Trusted_Connection=True;TrustServerCertificate=True;Command Timeout=300"