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.
Post your comment on this topic.