Wednesday, November 9, 2011

EXPORT Project MDL

# Connection to Workspace
# OMBCONNECT rep_owner/rep_owner@localhost:1521:orcl USE WORKSPACE 'My_Workspace'
# show the prompt
# set OMBPROMPT ON
# List Projects
#
# (c) Ciber Nederland John Minkjan
#         V001    Validated against OWB11gR2
#
set RootDir "C:\\temp\\"
set projectList [OMBLIST PROJECTS];
foreach projectName $projectList {
    OMBCC '$projectName';
    file mkdir $RootDir$projectName
    puts "exporting $projectName to MDL file"
    set exportFileName [string map {\\ /} [concat "$RootDir$projectName\\$projectName.mdl"]]
    set exportFileLogName [string map {\\ /} [concat "$RootDir$projectName\\$projectName.log"]]
    OMBEXPORT MDL_FILE '$exportFileName' FROM PROJECT '$projectName' OUTPUT LOG TO '$exportFileLogName'
OMBCC '..';
};

No comments:

Post a Comment