Versions Compared

Key

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

...

This 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
    languagetext
    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
    languagetext
    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"