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 SQL Server license from Geotech.
2. A computer to run SQL Server on. This can 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.
3. 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. .
4. 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.
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.
7. 6. Add the ODBC Control String to the settings. For instruction on how to do this download How do I create an ODBC Data Source to SQL Server.