What is required to run Enviro Data on SQL Server?

Many clients with larger database want to keep Enviro Data database on SQL Server for performance and safety reasons. To do this you need:

1. A computer to run SQL Server. This could be a regular computer, but a server class machine would be preferred. The computer does not need to be dedicated and it can be used for other things, given significant resources. It could also be an Azure VM with SQL Server.

2. A copy of Microsoft SQL Server. 2016 or later, Standard or higher, would be best, although anything newer than 2012 will work. After some recent bad experiences (poor performance), we do not recommend using SQL Server Express. Although it works for some clients, you may not be able to upgrade your data to the full version. .

3. A copy or the Enviro Data database in SQL Server format. Geotech can migrate your current Enviro Data Access database file(s) to SQL Server  for you, if needed.

4. Client Access Licenses (CALS) for each named user.

#12