DB Options

This area hold all options related to the database and it’s maintenance.

Local DB location

This option changes the location which is used for caching database and templates. By default (i.e. if this is not set specifically) location used is ‘%Appdata%/Tabular/’ . Please contact SolvencyIISolutions before changing that as ti may result in bad performance of the application.

Update current return path in the DB

This option will update the path registered for the specific return in Database. It will be updated to the current location of the return – this should be used when you move the return to a new location. This can be used to remove the Not Registered message on starting workbook.

Update GoldenCopy return variant table

This option allows to change the goldencopy return for the current return. More info on that you can find in this help article.

DB maintenance

The first two buttons – Compact and Shrink are used to optimize the database to reduce the size of the .sdf file. The third one “Repair” is used in case of some corruption in the database and can help to restore its normal functioning.

Update all returns with a new central DB path

This option is used to change the path to the database that is in each return Custom properties. It is used when the location of the database is moved. Note that in order for it to work Tabular returns should be able to be found by the system, which means they should be at the same path logged into the database, if they are moved as well and this path is no longer valid nothing will be updated. If you change location of the Database we strongly advise that you contact SolvencyIISolutions support team to guide you through the process and ensure that it goes smoothly.

Central DB settings and location

This option will open a dialogue where you can configure the type of database used: SQL Compact or SQL server and also modify the connections string of the database. Please do not change by yourself and contact SolvencyIISolutions support team.