Kbase P24306: Is there issue for doing Dump Definition, Sequences, Data, and User using Data Administration and Lo
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Is there issue for dumping Data Definitions, Sequences, data, and User and load everything into the same DB again ?
FIX:
There is no problem in dumping and loading into the same database, but when dumping and loading data you have to consider the following:
- One of the purposes of dumping data out of a database and loading it back into a brand new database is to reorganize data physically so that performance will improve. That will *not* be achieved by dumping and loading back into the same database in Progress versions up to version 8. In version 9 and OpenEdge 10 some performance improvement can be achieved if the dumped data is loaded into a brand new, empty storage area.
- If you are dumping data because of data corruption, or because you had to force access into the database with the -F option, dumping and loading into the same database is highly discouraged: in this case the purpose of dumping and loading is to re-baseline your database to a state where at least the physical integrity of its data can be guaranteed; loading data back into the same corrupted database would defeat that purpose, as the target database may still be corrupted physically.