Versions Compared

Old Version 3

changes.mady.by.user CBE

Saved on

compared with

New Version 4

changes.mady.by.user CBE

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Currently the database command can be used to upgrade the database to the expected schema.

Code Block
languagetext
themeRDark
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
languagetextthemeRDark
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 does not have sufficient rights to perform the upgrade. 

Code Block
languagetextthemeRDark
AMANA.SmartTaxBalance.Web.Api.exe database --upgrade --connectionString="Server=(localdb)\MSSqlLocalDb;Database=taxbalance;User ID=sa;Password=sa;Trusted_Connection=True;TrustServerCertificate=True"

...