skip to main content
OpenEdge Data Management: DataServer for ODBC
The DataServer Tutorial : Using the Adjust Schema utility
 

Using the Adjust Schema utility

The Adjust Schema utility allows you to compare your ODBC Schema holder information with the original OpenEdge database, updating any OpenEdge attributes in the schema holder. These attributes include field names, labels, help, validation expressions and messages. You must be connected to the OpenEdge database and the schema holder that you want to compare to before running this utility.
To adjust your schema:
1. From Data Administration, select DataServerODBC UtilitiesSchema Migration ToolsAdjust Schema. The Adjust Schema dialog box appears:
If you leave the **all** in the Files To Compare section, all objects are compared and the changes are made. If you only want to compare certain objects, you must enter the information in the following format:
<comma-separated list of tables>;<comma-separated list of sequences>;<comma-separated list of views>
For example:
customer,order;next-order-num,next-cust-num;custview,ordview
2. Click OK.
All of the objects that are compared will be displayed on screen as they are processed.