The Enviro Data database file structure changes with each minor version upgrade -- 8C to 8D for example. This is done to enhance functionality. This means that any older Version 8 or 2012 databases you have been using need to be converted into the new format.
While we recommend using the EDITOR and VIEWER programs that are consistent with the database version in use, an Enviro Data 8 database can be used with the Enviro Data 2012B programs. However, there will be errors when creating a new database, a subset and/or preparing lab reference files with the older version database.
Convert an Access Database,
For any Access databases, you will use the Enviro Data 8 EDITOR to make the conversion and the EDITOR must be run from the EData8 folder with its associated files. This can be done by simply opening the EDITOR and use Attached Database button to convert the older database. This will create a new file with (Version8) added to the end of the filename and also create a backup of your old file. The original file will remain unchanged.
Convert a SQL Server Database
Any SQL Server databases will need to be converted to the Enviro Data 8 table structure that matches the version being used. This conversion adds several new tables and fields to the existing database using scripts. Geotech can perform the upgrade for you during a short Teams meeting or, provide the scripts to your IT Dept. Please contact