Slider

Upgrading / Database Conversion

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 need to do these tasks, and do not have a Version 8 program available, contact Geotech Support for assistance.

In the new Enviro Data 8 database file structure changes were 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.

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. Simply open the EDITOR and use Attached Database button to convert it. 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 This email address is being protected from spambots. You need JavaScript enabled to view it. to set this meeting up.

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. 2010 database will need to be converted into the 2012 format using the 2012 Editor before trying to convert it into the Ver. 8 format. If you need assistance with this, please contact support.

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. Simply open the EDITOR and use Attached Database button to convert it. 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 This email address is being protected from spambots. You need JavaScript enabled to view it. to set this meeting up.

An Enviro Data database contains a complex set of tables each with specific structures and requirements for their fields. In order to protect the data integrity, in Version 8 we have not only added some new tables and fields, but also increased referential integrity and also checking of your data during the upgrade.

Before starting, if you are trying to upgrade an old table that you have not used in a while and are not sure what version it is in, you need to determine that first. You can do that by opening the database in Access or Enviro Data, clicking the F11 key which opens the table listing and then opening the Versions table. The table's version number should be shown in the first record. An Enviro Data 2012 table can be updated simply by attaching to it in the EDITOR and following the prompts. Databases used with version 2010 will need to be converted using version 2012 before upgrading to Version 8.

To ensure that everything is converted correctly into Version 8, Enviro Data displays an Update Structure Summary showing the number of records in the main tables both before and after the conversion. The example below shows the main tables before being converted. (Note other tables are also being updated in the process but only the main ones are shown.)
update data structure form before conversion

If the structure in one or more of these tables violates data integrity, possibly because it had been modified, or some other problem, this will cause the conversion to be flawed but the resulting database will still be attached to the Editor. When this happens, you will see in the form shown below that one or more “Converted” tables will not contain the same number of records that the “Initial Record Count” showed.

YOU MUST PAY CLOSE ATTENTION TO THE UPDATE STRUCTURE SUMMARY FORM TO MAKE SURE YOUR DATA WAS CORRECTLY CONVERTED.
Update Structure Summary form with Errors

In the above case, an extra field had been added to the Analyses table by the client. Additionally, the RegLimitType table contained some records with descriptions that were not unique.

The issue we encounter the most when upgrading a database to the Ver. 8 format is where a client has modified one or more of the tables in Enviro Data by adding additional fields. In the case above, the extra field in the Analyses table was simply deleted.

A more difficult issue to find is a problem in a lookup table. If a lookup table fails to convert you will not see it listed but this problem may prevent a related table to not convert along with other tables dependent on it. Most lookup tables contain a field for both a code and for the code’s description and all descriptions must be unique in Version 8. This was not the case in Ver. 2012.

So far, the most common problem of this type has been in the RegLimitTypes table where limits were imported from a spreadsheet with descriptions greater that this Enviro Data field holds, 50. This means the RegType (the description), is truncated and may end up identical to one for a different reg. limit.

The easiest way to find these is to open the table in question, sort the description field alphabetically and look for long descriptions that match. The fix is to abbreviate them to 50 or fewer characters so they are unique. In the example below (from the same database as above) the Reg. Limits had been imported with some of their descriptions longer than 50 characters. When these were truncated, they became identical. See below, and how they were corrected.
regLimitConvtBad
Reg Limit Types with unique descriptions

This fix also applies to other lookup fields where the descriptions may not be unique. The issue is figuring out which tables to check. You can get a clue of which lookups to check based on which of main table (starting with Sites) that did not convert correctly. For example, if the Stations table had a problem, check the lookups shown under Stations using Manage Lookups in the Editor. In the example above, you probably don’t have to check every Station lookup, only those in the “Show Less” tab of the form.

Manage Lookups form Stations section
View each lookup in Datasheet view sort the description field and look for identical values and correct any you find. Then move on to the next lookup table for the appropriate table. If you can’t find the problem there, you can click Show More and check more of the Stations lookups.

After a successful upgrade, we recommend moving the new Version 8 database into the C:\Enviro\EData8 folder if you are working on a local copy.

Finally remember, when you start the conversion process the source database is copied with “_GCSBackup” appended to the file name. Additionally, the source database is not touched at all, so you have two backup copies.

Any custom queries or settings created in Version 2012 are in the Setting2012 file and this file needs to be converted for use in Version 8.

  1. Open the Version 8 EDITOR,
  2. Click on Attach Database,
  3. Click on Attach Settings,
  4. Select the C:\Enviro\Edata2012\Settings2012.mdb file,
  5. You will see a message informing you that Enviro Data needs to update the Settings file.
  6. Click “Yes”. 
  7. After the update finishes, rename the file to something more relevant to Version 8 and move it to the C:\Enviro\Edata8 folder.

This error can occur after installing Enviro Data 8 on a computer with an older version of MS Office. Please see How do I fix an Object Library Error or Missing or Broken Reference Error? for a simple fix.

missing reference error