Patriot uses the Microsoft SQL database. Patriot can be installed with MS SQL Express which is provided free of charge or with a fully licensed MS SQL 2005/2008 package.

Why does Patriot use an SQL Database?

  Speed and Network Efficiency
      MS SQL utilises server hardware architecture to a higher degree than standard databases. This prevents the
      bottlenecks that occur when data is processed on workstations.  SQL databases are also more adept
      at quickly processing very large volumes of data. In-house testing with Patriot showed a 50 fold increase in
      the number of logged signals when compared to software using non SQL databases. 

  Compatibility
     Third party software can access Patriot SQL data directly. This allows easier integration with reporting and
     analysis applications,  accounting packages and other 3rd party software.

  Data Replication and Warm Backups
     The Patriot SQL database is backed up with no interruption to alarm signal processing. Backups are
     configured in Patriot to run at preset intervals.  This ensures that your Patriot backup server has current
     data available at all times.  Automated data restore to the Patriot backup server is an important feature
     available in Patriot Enterprise.



Patriot Enterprise Database Mirroring  

Patriot Enterprise 6.1 features support for Microsoft SQL database mirroring.  Available with SQL Server Standard or Enterprise, this feature enables Patriot to maintain two identical databases on two separate SQL Servers.  This ensures that in the event of a failure of the primary Patriot SQL Server, the mirrored server will maintain service with no data loss.  

The SQL servers must be in the same domain but can be located remotely from each other provided that there is fast, reliable TCP/IP connectivity between the sites.  

Patriot provides a simple applet which automates the change in operating mode required to bring the secondary SQL database into service.  Every Patriot system also includes free backup server licensing enabling CMS Managers to configure duplicate facilities which ensure ongoing data and operational security.