Migrate FrontBase DB from one OS to PostgreSQL DB to another OS

No headers

Do an upgrade on the original system (e.g. some Windows Server or Mac OS with embedded FrontBase DB)
Run the DB migration during upgrade process
Finish upgrade process – the new version of WHD v12.0 should use embedded PostgreSQL DB
Now, stop WHD Application
Backup database on the original server (e.g. using PGAdmin tool or PostgreSQL commands http://www.postgresql.org/docs/9.1/static/backup.html)
Install/Deploy WHD v12 on the other system
Go through Getting Started Wizard, choose embedded DB (default PostgreSQL)
Once finished, stop PostgreSQL DB
Restore database from the original server to new server (again using PGAdmin tool)
Start DB on the new server
Open WHD in browser
If the Domain name of the new server is different to the domain name of original server, navigate to Setup -> General -> Options and change Server DNS Name.

Tags