Kbase 21874: How To Move a Table From One DB to Another in Roundtable
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/7/2002 |
|
SUMMARY:
To move a table from one Database to another in Roundtable, you would move a PFILE object (with all its assigned PFILEs) from one PDBASE to another PDBASE.
EXPLANATION:
Since the table is moving to another Database, the table assignment should NOT be removed from the workspace. Instead, only the table assignment should be removed from the old Database.
SOLUTION:
Follow these steps to remove the table assignment:
1) Check out the PDBASE (DB) object to a task.
2) Expand the PDBASE object (View > Expand Object).
3) Select the table in the browse (Tables in '<db>').
4) Remove the table assignment (File > Delete Object Assignment).
At this point, the PFILE (table) object is still assigned to the workspace but not to the Database. The table can then be assigned to the "new" Database by the following steps:
1) Check out the "new" PDBASE object to the task.
2) Expand the PDBASE object (View > Expand Object).
3) Assign the table to the expanded PDBASE:
a) File > Assign Object.
b) Select the table from pop-up dialog and click OK.
c) Enter local table name (if necessary) when prompted and
click OK.
Now, run Update Schema to synch the physical Database. If the physical Database is already current, choose Skip... > Skip All before clicking Update.
References to Written Documentation:
Progress Roundtable User's Guide