Kbase P103865: How to copy a database from one location to another and change the storage areas.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/22/2005 |
|
Status: Unverified
GOAL:
How to copy a database from one location to another and change the storage areas.
FIX:
To copy of a database and make changes to the storage areas you need to do a dump and load.
Start with dumping the df file.
Edit the df file making changes to the tablename where a table is located.
Search for ADD TABLE
The next line will be AREA <AreaName
Change the Area name to the new area name.
Make sure when you create the new database all the area names are included in the <DBname>.st file.
Now load the df and .d files into the new database.
This is no way to change the storage areas tables are located in when using the procopy command.