Data Migration from GEMS5.4 to GEMS 6.0

From ICISWiki

The following information stored in the GEMS 5.4 database can be migrated to GEMS 6.0.

1. markers stored in the gems_marker_detector table

2. molecular variants stored in the gems_mv table

3. mapping feature stored in the gems_locus table and is linked via the gems_mv table

4. collection of names for each marker and allele stored in the gems_names table

5. information on markers, alleles, etc can be stored in the gems_annotation table

Stored procedures used to migrate data:

1. get_next_value.sql

2. insert_gems_entity.sql

3. load_gems_marker_detector.sql

4. load_gems_gems_mv.sql

5. load_gems_names.sql

6. load_annotation.sql

Steps in migrating data:

1. Check for duplicate marker or allele values. Duplicate entries might need manual modification.

2. Execute the scripts.

1. Load the markers stored in the gems_marker_detector table by executing: load_gems_marker_detector(120,118);
2. Load detected variants stored in the gems_mv into the gems_detected variant by executing :  load_gems_mv(116);
3. Load synonyms of markers and detected variants into the gems_names table by executing : load_gems_names();