TableCheck

TableCheck.exe is a program that will read a schema file of database field names and types, and create a copy of an existing database to match the new table structure. The existing database is not modified.

To run:

1. Download Tablecheck.exe and the appropriate schema file into the same directory on your hard drive.

2. Run the program.

3. Use "File" | "Open" to open the old database.

4. Click "Convert".  An updated copy of the database will be created with the word "NEW" appended to the filename prefix.  A log will list the tables and any fields that were added or discarded.

IMPORTANT: Some older versions of the programs had misspelled field names. In this case the tablecheck program would not copy the existing data from that field to the new one. Be sure to read the tablecheck log to know if this has happened.

Download

Download TableCheck.exe 2010-03-08
Download i_EPIC schema file 2011-01-26

Note: new SCRP fields in Parameters table combine the numbers before and after the decimal, so each pair of old values becomes one new value. Also, the following values are discarded because they shared the same array location as other variables which were for newer versions:

S Curve 1 Ground Cover, S Curve 1 Soil Insulation (SCRP(5,1))
S Curve 2 Ground Cover, S Curve 2 Soil Insulation (SCRP(5,1))
S Curve 1 Labile P Concentration, S Curve 1 Phosphorus Uptake Factor (SCRP(11,1))
S Curve 2 Labile P Concentration, S Curve 2 Phosphorus Uptake Factor (SCRP(11,2))
S Curve 1 Scaling Factor (SCRP(15,1))
S Curve 2 Scaling Factor (SCRP(15,2))
S Curve 1 Reduction Factor (SCRP(22,1))
S Curve 2 Reduction Factor (SCRP(22,2))
Wind Erosion Soil Erodibility (PARM(8))
Snow Melt Rate (PARM(13))
Soil Temperature Lag Factor (PARM(15))
Temperature Insulation Limit (PARM(17))

If you run EPIC5300, you'll want to copy these from the original database.