Upgrading SQL Server
Both Clinical and Pracsoft use Microsoft SQL databases. Clinical and Pracsoft require two SQL Server instances.
Upgrade the server first, then upgrade the workstations.
- HCNSQL07 - Required. Hosts the clinical and financial data.
- ESP - Required. Used by functionality such as Insights, and if your practice uses a Tyro device.
The MedicalDirector ISO includes Microsoft SQL 2019 Express Edition. A new server role installation will create the SQL Server instances for you automatically but will not upgrade existing installations.
If you have a full SQL Server licence and are currently running Clinical and/or Pracsoft within SQL Express, you can upgrade to full SQL Server either before or after upgrading to Clinical / Pracsoft. In either case:
- Perform a Backup with the Backup Utilities.
- Follow the instructions supplied by Microsoft to upgrade both SQL Express Instances HCNSQL07 and ESP to your version of full SQL Server. This requires running the SQL installer twice.
