Progress
DataServer for
Microsoft SQL Server
Guide


Adjust Schema Utility

The Adjust Schema utility allows you to compare your SQL Server™ Schema holder information with the original Progress database, updating any Progress Attributes in the schema holder. These attributes include field names, labels, help, validation expressions and messages. You must be connected to the Progress database and the schema holder that you want to compare to before running this utility.

Follow these steps to adjust your schema:

  1. Select the utility from the Data Admin Tool DataServer MS SQL Server Utilities Schema Migration Tool Adjust Schema. The following screen appears:
  2. If you leave the **all** in the Files to Compare section, Progress compares all objects and makes changes. 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 
    

  3. Select OK.
  4. All of the objects that Progress compares will be displayed on screen as they are processed.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095