If you purchase FCS Express with the Security add-on, you have the choice of two database options

 

•Microsoft SQL Server

•Elevate DB Local Server

 

Click here for more information about compatibility requirements for Microsoft SQL Server.

 

We strongly recommend Microsoft SQL Server for your production environment.

 

Please note that before or after you purchase the security add-on, you must inform sales@denovosoftware which database option you would like. We can then customize the configuration file for your license.

 

Microsoft SQL Server

 

Microsoft SQL Server is the most robust database option available for FCS Express. This option is ideal if your organization already has an SQL Server installation and has experience with it. It is also ideal if you will be running several network installations of FCS Express, or many standalone licenses, or any combination of network and standalone licenses. Each of those installations will be able to use the same configuration, and share the same security system. Note that to use FCS Express with SQL Server, you must purchase your own license for SQL Server.

 

Elevate DB local server

 

The Elevate DB local server is a database that does not require a database server to be installed on any computer. The database files reside in a shared folder, and each FCS Express client accesses the database files directly. Multiple instances of FCS Express can access the database at the same time. This is the simplest option as it requires no extra installation of an additional database server. It does suffer from performance issues inherent to non-client server architectures, however, the security databases are quite simple and this may not have a practical impact in your organization. This option can be provided for free with purchase of your security system.

 

Because Elevate DB is not a client-server database, it is critical that you perform regular backup and restore tests in the event of data corruption. This is one of the reasons we recommend SQL Server, since it is much less prone to data corruption. Instructions regarding backing up your databases can be found here.