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 on. 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 recent version of Microsoft SQL Server. although anything newer than 2016 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. A SQL Server license from Geotech.
5. A Client Access Licenses (CALS) for each named user.
6, An ODBC connection set up on each computer that needs to connect to the SQL database.