NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
The MySQLtoPGSQL tool does not have any installation program. Just copy the folder to somewhere on the C-drive.
# Restore the 5.08.04 database <br/> [[Image:MySQLtoPGSQL1.png]]
# If there is already a dump.sql and/or views.sql in the folder, the tool will '''append''' to these files. So do not forget to delete these files between working with different countries.
# Click on run.bat to start the tool.
# Rename the MySQL dump.sql that you have in the original backup folder to e.g. MySQLdump.<br/>[[Image:MySQLtoPGSQL2.png|500px]]# When the tool has finished , scroll through up in the window and check if there are any error messages. <br/> [[mage:MySQLtoPGSQL3.png|500px]]# If not, copy the raw dump.sql and/or views.sql files to the original backup folder.
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 format but the table structure, etc. are still 5.08.04 and needs to be upgraded to V6.0.
===Restore the raw dump and upgrade===__NOEDITSECTION__
{{Warning| Do '''not''' restore GIS database and map data. You need to rebuild the sandbox and by restoring the map date you will copy '''overwrite''' the ArcGIS 9.310.1-version of ''imsma.mxd'' to in C:\IMSMAng\server\gis\mapswith the ArcGIS 9.3.1-version.}}
Did the backup from the country contain the attachments?
Restore the raw PostGresSQL dump on a computer with IMSMA V6.0 and scan the restore log for error messages.
Start the TrayLauncher for starting the upgrade scripts. When the upgrade scripts are done:
# take backup.
{{Note that a | A database that is already upgrade to V6.0 with one of the earlier RC/Beta early Betas might need manual manipulation e.g. Beta 2 to Beta 3.}}
===Templates - Run the image tool===__NOEDITSECTION__