eNICQ 5 Installation Options
Vermont Oxford Network recommends using an existing Standard or Enterprise Edition SQL Server installation to host the database for the additional security, stability and extensibility that option offers.
If you do not have the resources or IT staff to support a server hosted database, the installer contains a free version of SQL Server Express 2012 that can be installed locally on your client computer.
SQL Server® Express Edition, installed locally
The eNICQ 5 client application and SQL Server® Express database are installed on a single workstation.
Advantages:
- Easy to install, can often be implemented with minimal IT support
Disadvantages:
- Risk of data loss if the local machine is damaged, upgraded, replaced
- Establishing a reliable backup protocol will require additional IT support
- Security of PHI data depends on securing access to the machine itself
- Can only have one client machine for data entry
SQL Server® Standard or Enterprise Edition, installed on server
The eNICQ 5 client application is installed on one or more workstations while the database is hosted on your existing SQL Server® Standard or Enterprise Edition.
Advantages:
- No risk of data loss if the local machine is damaged, upgraded, replaced
- Backups can be managed at the server level by a Database Administrator
- Security of PHI data can be managed at the server level
- Can have multiple client machines for data entry
Disadvantages:
- Requires professional IT support to implement