Running Database Scripts

Top Previous Next

The Server Manager tool can run scripts against the selected Complete Time Tracking database without the need to install and configure database connection drivers such as ODBC, JDBC or ADO.NET. A script is a sequence of commands that perform various actions, such as retrieving or updating data. Scripts support several commands such as SQL statements, output statements, conditional execution, and the use of variables that can be saved between runs allowing the following run to resume where the last run finished.

Scripts can be used to extract custom data that is otherwise not possible through the pre-defined reports in the Complete Time Tracking user interface. This data can be used in other reporting tools or applications such as Microsoft Excel.

Scripts can also be used to add, modify or delete users, categories, time entries and other data programmatically, or to perform maintenance tasks, such as under the direction of Complete Time Tracking support staff.

HOW-TO

Run a Database Script

1.	Select the appropriate database to run the script against from the databases list.

2.	Click the Script button.

3.	Browse to and open the database script file.

4.	If the script file is encrypted enter the password for the script.

Note: The Complete Time Tracking Professional Server will be stopped while the script is run to ensure exclusive access to the database. Users will be unable to log in or use Complete Time Tracking while the script is running. The server will be automatically started when the script is complete.