To move a database to a different location using an operating system copy or move commands, use the following steps:
(1) Create a current database structure file using the prostrct list command, as follows:
prostrct list <dbname> current.st
where <dbname> is your current physical database name.
(2) Make sure sufficient disk space exists for all 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 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 all database files to their new location.
(5) 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 'new' physical database name.
(6) If you are using OpenEdge Explorer to start your new database, go into its Configuration and change the new database setting to be in the correct path (in the new location). |
