In the new Enviro Data 8 database file structure, changes have been made to several of the tables to enhance functionality. This means that any 2012 databases you have been using will 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 or subset, and/or preparing lab reference files with the older version.
If you have databases from Version 2010 or older, these will need to be converted into the next newer format before converting to Ver. 8. In other words, a Ver. 2008 database will need to be converted into the 2010 format using the 2010 Editor and a 2010 format will need to be converted using a 2012 Editor before trying to convert it into the Ver. 8 format. If you need assistance with this, please contact support.
Upgrading an Access Database
When you upgrade Enviro Data, you will use the new Enviro Data 8 EDITOR to upgrade your database and, the conversion and the EDITOR must both be run from the EData8 folder with its associated files. Simply open the EDITOR and use Attached Database button to convert you existing current database. This will create a new file with (Version8) added to the end of the file name and also create a backup of your old file.
Convert a SQL Server Database
Your SQL Server databases will need to be converted to the Enviro Data 8 table structure to add several new tables, and new fields to existing tables using scripts. Geotech can perform the upgrade for you during a short WebEx. Please contact