Maintaining TraCS Office Databases

A database connection tells TraCS how to connect to a database.  For example, TraCS knows where the Users database is stored and how to connect to it because of connection information about the User database, which is entered in the Database Connection Editor.   The Database Connections Editor takes the settings entered in the panel and generates a connection string to be used by TraCS to access your data. A database cannot be accessed by TraCS unless the correct connection information is specified in the Database Connections Editor.

There are five databases that make up your TraCS installation: Data, Custom, Support, Log, and Users. 

Data contains all the form and incident data. 

Custom contains all the code tables that are managed by the agency, these tables appear on drop down lists.

Support contains all the code tables that appear on drop down lists when an officer fills out forms the tables in this database is maintained by the State.

Log contains logs of actions performed in TraCS.

Users contains user profiles and and access levels.

In SQL Server, these databases are typically named:

• tracs_data

• tracs_custom

• tracs_support

• tracs_log

• tracs_users