Export/ Copy Tree
From within
Application Designer on the Source database
1. Click on the Upgrade tab (in the lower left
corner).
2. Insert -> Objects into Project.
3. Select Object Type = Tree and hit enter for a
list of trees.
4. Highlight desired tree/s and hit insert.
If the Tree
Structure does not exist in the Target database, do the same steps for the
Object Type = Tree Structure.
5. Save, enter project name.
6. Tools -> Upgrade -> Copy.
7. Enter Target Database information and select
copy.
Once this
finishes the done field should now be checked back in Application Designer.
The
Application Designer will only export the system tables associated with the
trees. It is necessary to export the
application tables separately to get the node and detail descriptions.
Note:
You may Use below navigation if tools version are different or you want to keep backup of tree in dat file, You can use Export and Import utility from below menu navigation, if Application Designer doesn't work for you
Main Menu > Tree Manager > Tree Utilities
Acquiring Structure Information
- Structure name
SELECT TREE_STRCT_ID FROM
PSTREEDEFN
WHERE
TREE_NAME='YOUR_TREE_NAME' and EFFDT='YOUR_EFFDT';
- Application Tables associated with Tree
SELECT TREE_STRCT_ID,
LEVEL_RECNAME,
NODE_RECNAME, DTL_RECNAME FROM PSTREESTRCT
WHERE TREE_STRCT_ID =
'YOUR_TREE_STRUCTURE';
- Migrating Level, Node and Detail Descriptions
1) Using
DataMover, log into Source database
2) Create
script:
SET LOG C:\TEMP\MIGRATEDATA.LOG;
SET OUTPUT C:\TEMP\MIGRATEDATA.DAT;
EXPORT YOUR LEVEL_RECNAME;
EXPORT YOUR NODE_RECNAME;
EXPORT YOUR
DETAIL_RECNAME;
3) File/Save/
C:\TEMP\MIGRATEDATA.DMS
4) File/Run
5) Verify
Script Completed message
6)
File/Exit
7) Check
for successful export
8) Print
off logfile
9) Using
DataMover, log into Target database
Create
script:
SET LOG
C:\TEMP\IMPORT.LOG;
SET INPUT C:\TEMP\MIGRATEDATA.DAT;
SET IGNORE_DUPS;
IMPORT *;
10)
File/Save/ C:\TEMP\IMPORT.DMS
11)
File/Run
12) Verify
Script Completed message
13)
File/Exit