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.