Kbase P25954: How to move the location of a database using operating system commands.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/09/2007 |
|
Status: Verified
GOAL:
How to move the location of a database using operating system commands.
FACT(s) (Environment):
UNIX
Windows
Progress 8.x
OpenEdge 10.x
Progress 9.x
FIX:
If you choose to move a database using an operating system copy or move command follow these suggested steps:
1) Create a current database structure file using the prostrct list command as
follows: prostrct list <dbname> current.st
(Where <dbname> is your physical database name)
2) Make sure sufficient disk space exists for all the new database extents in
the new database location.
3) Edit the "current.st" database structure file and modify the path(s) and/or
file name(s) to reflect the new database's new location. Save the modified
information in a new database structure filename such as "changed.st".
4) Using the operating system's copy or move commands, copy or move the files to
their new location.
5) Finally, update the the new .db file with the current information from the
changed.st as follows: prostrct repair <dbname> changed.st
(Where <dbname> is your physical database name)