Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

How to perform a schema upgrade with a runtime license

« Go Back

Information

 
Article Number000020875
EnvironmentProduct: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Question/Problem Description
How to perform an Application Schema upgrade with a runtime license
How to use -rx to modify the database Schema with a runtime license
How to update a Windows 64-bit OpenEdge database schema using the Windows 32-bit GUI client installed with the database license.
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution
Starting a progress session with -rx parameter allows getting access to Progress Procedure Editor.
  • Using -rx -p _dict.p allows access directly to the Dictionary UI
  • Using -rx -p _admin.p allows access directly to the Administration UI where a .df can be loaded.
  • Note - neither of these options allows access to "Table Contents (.d file)..." to load Dump/Load data.  This can only be used to Dump/Load schema changes .df files.  A full development license such as OpenEdge Development Studio or ABL Development license is necessary to dump data using The Data Dictionary or Data Administration tools.

If you need to only load schema changes from a .df do the following:

1. In your Development environment,create a program (<yourProgram>) containing the following:

RUN prodict\load_df.r (SESSION:PARAMETER).

2. Compile and save the r-code.

3. Deploy the r-code to the runtime environment.  As an alternative, the source code .p file can be deployed if it is encrypted with XCODE.

4. From the command line, start a session using -rx and run the following:

On Unix: pro <dbname> -rx -p <yourProgram> -param <yourdf.df>
On Windows from proenv: prowin32 <dbname> -1 -rx -p <yourProgram> -param <yourdf.df>
Workaround
Notes
References to Written Documentation:

Progress Articles:

000012310, Which OpenEdge products are considered runtime licenses?
000013457, How to encrypt a source code using Xcode
Attachment 
Last Modified Date3/27/2017 7:00 PM