CPI has built a replicated Computerized Criminal History (CCH) on-premise database for the Alabama Law Enforcement Agency (ALEA). The project included the design, configuration, testing, and implementation of the replicated SQL CCH database and associated services.
CPI set up and configured SQL Server Replication in transactional mode. This technology updates the data in the Reporting Database in real-time and does not impact the availability of the data or the database. ALEA is now able to access data reports without affecting the primary CCH database.
The scope of work for this project included:
- CCH Reporting Database using SQL Server Replication
- Data Model
- Data Dictionary
- Hardware sizing and configuration recommendations
More about the OpenFox Criminal History Application (CCH): https://www.openfox.com/products/criminal-history-application/