Manage database

From Documentation
Jump to: navigation, search

Most of the data that you have in the software is stored on your computer, in a single SQL database file. No data is stored on our servers, except for licensing information. This has a benefit of higher speed and improved privacy when accessing the data. However, it has also a drawback - if something happens to your computer or the hard drive - the data will be lost. Therefore, we recommend to back up your data regularly.

Back up and restore functions may also be used to copy data from one computer to the other.

Backing up database

Go to System->Database->Back up database in the Main menu and follow the instructions on the screen. In most cases, you will want to use default settings to back up your data. Backup is stored in a single file, and you can save it on your flash disk, other hard drive, attach to E-mail message etc. You can also password-encrypt your backup if you want.

Restoring database

To restore the database, you must have a backup file produced by the "Back up database" function of the software. Go to System->Database->Restore database in the Main menu and follow the instructions on the screen.

CAUTION! When database is restored from a backup file, all your current data will be lost.

There is no way to retrieve the data that has been erased during Restore operation, so be careful.

What is not included in the database?

The database contains 99% of the data that you would consider useful or valuable. But there is also some data that is stored on directly on the file system and not in the database. This data includes:

If you would also want to back up any of the items above, please check the Technical details section

Technical details

How to find database file on the hard drive?

First of all, you need to determine your Windows user profile folder. To do that, open Windows Explorer, type %APPDATA% in the navigation bar and hit Enter (yes, you need to put the percent signs before and after the APPDATA word). Next, find a folder with the application's name and enter it. You will see one more folder inside with the 4-letter application code, and inside that folder all data is kept.

The database file has .fdb extension, all other files and folders keep the information listed in the What is not included in the database? section

Technically, instead of doing the Backup/Restore ad described above, you can copy all data that you see in this folder. However, this has the following disadvantages vs. Backup/Restore:

  1. The total size of the files will be significantly greater compared to the backup file
  2. File formats may not be compatible across different versions of the software. So if you take a copy of this folder from the software that is a couple of months old, there is no guarantee that the current version of the software will make any use of it.

How to access the data in the database?

We use Firebird SQL for database management. Please visit [their website] for details. If you are familiar with SQL, you can read data from / make changes to the database directly. This may be useful if you want to integrate our software with your own tools. The user name and the password to access Firebird database are the default ones: SYSDBA/masterkey. We are not able to provide any additional technical details about database structure, meaning of the data fields etc. But you are welcome to explore the database yourself.