Databases

PSIcapture stores configuration and batch information in Microsoft SQL server-based databases as described below in this topic.

Configuration Database: By default, configuration information is stored locally as an SQL Server Express 2012 (LocalDB) database in the ProgramData directory. If multiple workstations are used, the configuration information is stored centrally on the capture server and is synchronized to each network station through the Capture Services service. The client can migrate this database to a central SQL server instead of using LocalDB.

Batch Manager Database: By default, batch statistics are stored locally as an SQL Server Express 2012 (LocalDB) database in the ProgramData directory. If multiple workstations are used, the batch information is stored centrally on the capture server and is synchronized to each network station through the Capture Services service. The client can migrate this database to a central SQL server instead of using LocalDB.

Individual Batch Databases: When a batch is created, the batch contains its own local batch database in SQL Compact Edition 4.0 format. It contains statistics for its associated batch and is stored locally in the storage area of the batch.

If the configuration and batch information need to be stored somewhere else, select which database should be changed and enter the connection (for example: Server=JESSPC;Database=test;User Id=george;Password=open;).