Kbase P15522: How to move a database from one physical location to another.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to move a database from one physical location to another.
FACT(s) (Environment):
Progress 9.x
FIX:
Progress has no dedicated utility for changing the whole database location, but the methods for doing this are:
1. Restore a backup into the new location, using probkup/prorest. First create your new structure using prostrct create, then restore into this.
2. Dump and load into the new location. First create your new empty database in the new location, then load into this.
If the database hasn't been dumped and loaded for a while, then this might be a good opportunity to carry out this maintenance on it.
This option is the only supported method to move a database between different Operating Systems platforms.
3. Create a new target database in the new location and use procopy to copy the database into this.