NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
The dump file created with the tool is a '''raw''' dump file in PosGreSQL format which is possible to restore with V6.0.
''Raw'' as in it is PostGreSQL PostgreSQL format but the table structure, etc. are still 5.08.04 and needs to be upgraded to V6.0.
===Restore the raw dump===__NOEDITSECTION__
# Did the previous database that you worked with on the V6.0 computer had any attachments? If yes, delete them before restoring this database;
# Restore the raw PostGresSQL PostgresSQL dump on a computer with IMSMA V6.0;
# Scan the restore log for error messages;
#: the two error messages below are the so far '''encountered''' error messages but since table structure, relation rules between tables and contents of all {{IMSMANG}} databases are different there might be other error messages that you need to react on. As a general rule of thumb, between ''NOTICE: index "workitem_has_cdfvalue_workitemhascdfvalue_cdfvalue_key" does not exist, skipping'' and ''SqlDump restore Completed'' it is '''not''' normal to get any error messages;
===Check with the countries===__NOEDITSECTION__
* Import scripts
: All scripts needs to be reviewed and adapted to PostGreSQLPostgreSQL/V6.0, see [[Script changes 6.0]];
: Manual update of the column ''position'' in table cdfvalue need to be added.
* SQL views
: The SQL views needs to be redone in PostGreSQL PostgreSQL and may be redone from scratch or by editing view.sql (output from the extracting step).
* Do they have data stored in CDFs that there are standard fields for in V6.0?