NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
* Dump.sql and
* Views.sql.
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
[[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.
[[Image:MySQLtoPGSQL2.png]]
# When the tool has finished copy the 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.
Rename the MySQL dump.sql to e.g. MySQLdump and copy the raw PostGreSQL dump.sql and view.sql to your backup folder.