Tax Balance database

Owned by CBE
Last updated: Feb 08, 2024
1 min read

To store application relevant data Tax Balance uses a Microsoft SQL Server database.

Install Tax Balance

Tax Balance requires access to a SQL Server to use for storing relational data. You must create the database ahead of time.

Schema

Tax Balance maintains its own schema - it will update the schema when you start the application server.

Starting Tax Balance without database upgrade

It is possible to skip the database upgrade during the startup process. This is helpful, when the configured database connection is not allowed to make any changes to the schema, because of security restrictions. 

If the upgrade is skipped, it must be performed manually beforehand. Lookup up command line section for further information.

In general, the following start argument can be used to skip the database upgrade:

AMANA.SmartTaxBalance.Web.Api --skipDatabaseUpgrade

When using IIS

  1. Go the the application folder and open web.config for editing

  2. Locate the xml node configuration → location → system.webServer → aspNetCore

  3. Change the node attributes to
    processPath=".\AMANA.SmartTaxBalance.Web.Api.exe" arguments="--skipDatabaseUpgrade".
    Leave the other attributes unchanged.

For Tax Balance versions prior 23.2 the following change should be made:
Change the value for attribute arguments from .\AMANA.SmartTaxBalance.Web.Api.dll to .\AMANA.SmartTaxBalance.Web.Api.dll --skipDatabaseMigration