Kbase P103203: ProToMss did not recognize SQL keyword when creating script
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/27/2005 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
ProToMss did not recognize SQL keyword when creating script
The keyword "function" was not changed to "function_"
ProToMss failed when SQL keywords are used as object names
CAUSE:
Bug# 20050413-015
FIX:
Upgrade to R10.0B03 or higher.
If upgrading is not possible than a workaround is:
1. Modify the generated SQL script by adding an underscore to the end of the field name making it "function_" instead of "function".
2. Run the script in Query Analyzer to create the objects.
3. Pull the objects into the schema holder.
4. Run the Adjust Schema utility.
5. In the data dictionary, modify the "function_" Progress field name to be "function".
6. Verify that all field's Order numbers agree with the original Progress Database
The mapping between "function" and "function_" is now done.