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:

  1. Perform a Backup with the Backup Utilities.
  2. 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.