Appendix E - Exporting Data from Production DB and Converting into OWL File
This process will convert the currently existing database into a backup owl file stored in app/protégé/data/Protégé_xx/<PROTÉGÉ INSTANCE>. This file can then be used to be converted back to an OWL / RDF database, creating new tables and indexes to reflect any database related code / schema changes. The same owl file can also be used to update Dev, QA, and Stage.
- Advertise that the production server will be going down.
- Run 'sh shutdown_protege_server localhost:2633.'
- Type 'ps -ef | grep rmiregistry' to retrieve the rmi regisry ID to kill.
- Once the ID is determined, type 'kill -9 <rmi registry ID> '.
- Open up a Protégé Client instance from production environment, and click 'Create new Project, Check the 'Create from Existing Sources' box, Select OWL / RDF database and click 'Next', Select OWL Database and click 'Next', enter all necessary database information and click 'Finish'. The project should appear on the GUI.
- Click File, Convert File to Format, OWL / RDF file and convert. This will create an OWL file using the data from the database. Save the project as 'Thesaurus<YYMMDD>' or 'BiomedGT<YYMMDD>. Store this owl file in app/protégé/data/Protégé_x.x/<PROTÉGÉ INSTANCE>.
