-- In-place Design Repository Upgrade from BETA2 to Production

SPOOL LOG.TXT

ACCEPT V_HOST PROMPT 'Host Name: '
ACCEPT V_PORT PROMPT 'Port Number: '
ACCEPT V_SERVICENAME PROMPT	'Service Name: '
ACCEPT V_USER_NAME PROMPT 'Existing Repository Owner Name: '
ACCEPT V_USER_PASSWORD PROMPT 'Existing Repository Owner Password: ' HIDE
PROMPT 
PROMPT Review above entries and press
ACCEPT V_DUMMY PROMPT ' <ENTER> to continue or Ctrl-C to cancel'

PROMPT Start Design Repository upgrade from BETA2 to Production...

PROMPT Connect to repository owner ...
WHENEVER SQLERROR EXIT FAILURE
connect &V_USER_NAME/&V_USER_PASSWORD@(DESCRIPTION=(ADDRESS=(HOST= &V_HOST )(PROTOCOL=tcp)(PORT= &V_PORT ))(CONNECT_DATA=(SERVICE_NAME= &V_SERVICENAME )))
WHENEVER SQLERROR CONTINUE


PROMPT Invoke upgrade for data profiling
@dp.sql

PROMPT Invoke upgrade for bug 3927616
@fix3927616.sql

PROMPT Delete all location passwords to protect exporting in clear text
@deletePasswords.sql

PROMPT Invoke upgrade for bug 4877973
@fix4877973.sql

PROMPT End of the upgrade.
SPOOL OFF