Move database from one server to another
Sometimes you have to move a database from one old postgresql server to new postgresql server. I have done this before with PGAdmin using pg_dump and pg_restore.
My goal is however to do the move from within Omnis. Add new IP and click a button, sort of.
1. Can I do pg_dump / pg_restore from within Omnis?
2. Any tip how to do this in an other smart way?
I have done something similar moving a native datafile into a Postgresql server, so I know it is possible. I have a solution, but I am searching for a smarter way.
Any advice or input appreciated.
Manage your list subscriptions at lists.omnis-dev.com