Kbase P102753: How to create a table definition in multiple databases
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/04/2005 |
|
Status: Unverified
GOAL:
How to create a table definition in multiple databases
GOAL:
How to create schema without using Data Dictionary
GOAL:
How to load a definition file (.df) without using the Data Dictionary
FIX:
To create the same table definition in multiple databases, follow the following steps:
1. Using the Data Dictionary in one database, define the table.
2. Dump the table definition.
3. Connect to each of the other databases one at a time.
4. In the Procedure Editor do:
RUN prodict/load_df.p (INPUT "<definition file name>").
5. Repeat steps 3 and 4 for each of the databases to update.