[Bioperl-l] bioperl-db: Updating existing Databases with load_seqdatabase.pl and load_ontology

[Raphael A. Bauer]

Hello bioperl-l members,

i wonder how to perform a "safe" (incremental) update on a
working biosql schema.

My setup is the following: BioSQL schema on Postgres equipped with 
Swissprot (via load_seqdatabase.pl and GeneOntology (via load_ontology.pl).

Now i simply want to feed the existing BioSQL schema with
new versions of both databases.
The question ist how to do it in a safe way - especially so that no 
links in tables are dead and all information in the relevant tables and
dbxrefs is upadated too.

There is of course the --lookup flag for both scripts (and the 
update-on-new-date.pl for SProt) - but does it take care of everything?
Or would it be better to build up the database from scratch in order
to remain in a consistent state...

Many thanks in advance,

Raphael