Bug #2816
closedTry to migration without old temp tables
0%
Description
Migration from entry tables currently goes through old SAS-style temporary tables, but this is painful to debug and could embed some difficult to find error. So, I will try to write the data directly from the entry tables to the vegbank-style tables.
Updated by Michael Lee over 17 years ago
Try to migration without old temp tables >> Try migration without old temp tables
English... it's not just for breakfast any more.
Updated by Michael Lee over 17 years ago
Fixed!! This greatly streamlines the process and makes finding any errors in the process much easier, not to mention the process of fixing any errors. Also, this simplifies the final product, removing the strange SAS-era temporary table in the middle that was trying to save work by reusing code and code ideas.
This was well worth the time and effort it took (2.5 days).
Updated by Michael Lee over 17 years ago
Additional detailed QA of herbs with real level 5 data reveals no flaws in the new migration process. Ditto with trees- everything looks good. An automated "sanity check" would be nice to repeat, as was done last time.