Project

General

Profile

Bug #2816

Try to migration without old temp tables

Added by Michael Lee over 13 years ago. Updated over 13 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
Start date:
04/09/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2816

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.

History

#1 Updated by Michael Lee over 13 years ago

Try to migration without old temp tables >> Try migration without old temp tables

English... it's not just for breakfast any more.

#2 Updated by Michael Lee over 13 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).

#3 Updated by Michael Lee over 13 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.

#4 Updated by Michael Lee over 13 years ago

sanity check for stems added back.

#5 Updated by Redmine Admin over 7 years ago

Original Bugzilla ID was 2816

Also available in: Atom PDF