1. Adjust the SQL Width setting in the original OpenEdge database
- Connect to the original OpenEdge database using Data Dictionary.
- Select the table(s) containing fields with incorrect Width values.
- Go to Options > Adjust Field Width.
- Set the Width of the field(s) in question to the required value.
2. Adjust the SQL Width setting in MS SQL Server database
- In the SQL Server database, select the appropriate table.
- Right-click on it and select Design.
- Choose the field in question and change the Length to match the value specified for SQL Width in Step #1.
3a. Re-pull the adjusted table definitions from MS SQL Server to the schema holder
- Connect to the schema holder database in Data Administration.
- Select the MSS schema as the Working Database.
- Go to DataServer > MS SQL Server Utilities > Update / Add Table Definitions.
- Re-pull the modified table(s).
3b. Synchronize additional table information not stored in MS SQL Server, e.g. labels, description, etc., between the schema holder and the original OpenEdge database
- Connect the original OpenEdge database to Data Administration.
- Go to DataServer > MS SQL Server Utilities > Schema Migration Tools > Adjust Schema.
- Enter the name of the OpenEdge database in the "Original OpenEdge DB" field.
- Enter table name(s) in the "FIles to Compare" section and click OK.
The OpenEdge database, schema holder database and MS SQL Server database should now be synchronized.
Using DBTOOL may also be an option but the utility will only make changes to SQL Width if it is found to contain data whose length exceeds the current setting
, e.g. SQL Width is 10 but the field contains 20 characters.
SQL Width is represented as MAX-WIDTH in a .DF file. Refer to Article 000011409, What is MAX-WIDTH or SQL_WIDTH in a df file?