Kbase P24076: How do I create schema holder from an existing schema holder?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/06/2009 |
|
Status: Verified
GOAL:
How to create the "same" schema holder for another platform and/or another version?
GOAL:
How to load a .df from one schema holder into another empty progres database?
GOAL:
How do I create schema holder from an existing schema holder?
GOAL:
How do I move schema holder from one machine to another?
GOAL:
How do I replicate schema holder for DataServer?
GOAL:
How do I upgrade schema holder to another version?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
DataServers
FIX:
NOTE: To migrate the Microsoft SQL Server DataServer from 9.1D or lower to 9.1E or OpenEdge Release 10.x, you need to create a new schema holder from scratch in the respective release since a new flag is placed in the meta-schema for the performance reason.
A. If the new schema holder and old schema holder are on the same machine, use the following commands to create a new schema holder; procopy, prodb or probkup/prorest
In the proenv prompt (in windows, Start > Program > progress > proenv; in UNIX, $DLC/bin/proenv) use the command shown below:
-procopy <existing schema holder name> <new schema holder name>
-prodb <new schema holder name> <existing schema holder name>
-probkup <existing schema holder name> backupfile and prorest <new schema holder name> backupfile
NOTE: If the source schema holder (existing schema holder) is in a different directory, specify the complete path including the schema holder name.
B. If the new schema holder and old schema holder are on different machines, you will need to dump and load the complete schema image of the foreign database that you are trying to replicate.
C. If you are trying to upgrade the schema holder version to another version, dump and load should also be performed.
1. Dump a .df from an existing schema holder.
Go to Data Administration -> Dump -> Table definitions -> when the list of tables comes up, select all (*) tables, then dump to a file.
2. Create an empty progress database. Empty progress database can be created using progress data administration GUI tool or using proenv prompt (in windows, Start > Program > progress > proenv; in UNIX, $DLC/bin/proenv) as
prodb <name of the schema holder> empty
3. Connect to the empty progress database created in step 2 as a single user mode. If proenv prompt is used connect to it using the following command:
prowin32 <schema holder name> -1 (Windows GUI client)
_progres <schema holder name> -1 (character client) or
pro <schema holder name> (UNIX single user command)
4. Choose the Tools -> Data Administration -> Data Admin > Load Data and Definitions > Data Definitions (.df files)... Choose the appropriate .df file dumped from step 1 and load it into the schema holder.
You can also use backup and restore to move the schema holder from one machine to another machine if the OS and progress version are the same .
NOTE: If you restore in a different machine or in a different directory than the existing schema holder, you can use the same name as original schema holder name or you can give it a new name. If schema holder backup file exist in a separate directory or media, you can specify the complete path including the file name.