Manage database

<< Click to Display Table of Contents >>

Navigation:  Managing application and database (ControlPanelFree) >

Manage database

Database management can be used for example to set up the database location and to run backups. This chapter covers the local database and cloud database. What this involves is explained in the introduction of the chapter: Local database or Cloud database.

 

Set up database

Set up database can be used to set up a database location. In TimeWriter Freeware this can be done locally or in the cloud. The default is set to: ‘Database on this computer’.

 

Do you want to work on the same TimeWriter database at another location or via a web browser? You can choose to put the database in the cloud. The database will then be located on one of our servers and you can access it from various locations. The wizard will direct you in this.

 

Backup and restore database

'Backup and restore database' allows you set up backups, remove them, restore them or archive them. The screen shows a tab sheet for both local and cloud backups.

 

When you work with a local database, the backups will be made in the folder: \data\xso_free\default\backup.
When you work with a cloud database backups are made on a location on the cloud server.

 

If you want to save a copy of a cloud backup in a different location, you can download it from the cloud.

If you would like to open a copy of a backup in TimeWriter without overwriting your database, you can do a restore to an archive. This archive can be opened again from TimeWriter under menu File | Open archive.

 

Transfer database

If you previously worked with a local database and you have changed to a cloud database (or vice versa) then you can transfer the database here to continue with the same database. You will see some information about the contents of the databases in both locations.

 

Click on week_prev to transfer the cloud database to the local database. The local database will be overwritten by the cloud database.
Click on week_next to transfer the local database to the cloud database. The cloud database will be overwritten by the local database.

 

Block database

Blocking a database will prevent it from being used after transferring it from a local to a cloud database or vice versa. A block message can be set up per database.

 

Fix database

If a database is suspected to be corrupted, you can check the database for errors here. If possible, you can then get the errors fixed. A backup is automatically made first. Local temporary files can also be deleted here.

 

Archive database

A database can be archived here by entering a customised self-selected archive name. Archives can also be deleted again as required. Archives can be opened in TimeWriter via menu option File | Open archive. An opened archive can be used in the same way as the main (Default) administration.