Database Backup and Restore

The time tracking database containing your defined categories and all recorded time can be conveniently backed up or restored at any time.

The database is backed up to a single file in a compressed format making it easy to transfer to a backup medium such as DVD-R, CR-R, USB key, tape, second hard-disk or other backup device.

Built-in automatic database versioning seamlessly upgrades previous version databases when they are restored from backup to provide full backwards compatibility.

Auto Start

The main time tracking window can be set to automatically start when you log in to Windows (and in the Professional edition automatically log in to Complete Time Tracking) providing convenient access to begin their time recording.

Time automatically stops recording when Complete Time Tracking is closed, Windows is shut down, or the system placed into standby or hibernate modes.

Server Manager Application (Professional edition)

The separate server manager application provides convenient alternative access to the server status and control and is useful in disaster recovery situations.

The server manager has backup and restore functions and can be used to restart the server if you are not logged into Complete Time Tracking. It is also used to manage the Complete Time Tracking databases and direct access users (see below).

This example server manager window shows the Databases tab which lists the separate Complete Time Tracking databases that are available.

External Reporting and Database Access (Professional edition)

Complete Time Tracking uses the Firebird database engine to store the users, categories, time entries and other information. Firebird is a fully featured, widely used, high performance SQL open source database.

Direct access to the Complete Time Tracking database is possible using ODBC, JDBC or ADO.NET with free drivers and data providers available from the Firebird web site. These connectivity options are commonly supported by third party data applications such as reporting systems.

There is one low-level read-write and two read-only users in the Complete Time Tracking database to facilitate updates and reporting by external applications. Of the two read-only reporting users one has a full view of data and the second a limited view. This provides some level of security when providing direct access to the database to different staff and systems.

Database schema, a schema diagram, and access and usage information are available. For more information please contact the technical support team.