Kbase P16902: Migrating the Progress database to MS SQL or ODBC compliant
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/21/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
ODBC DataServer
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Migrating the Progress database to MS SQL or ODBC compliant database fails and session consumes CPU
Migration from Progress to third party database using DataServer fails
CHANGE:
Manually modifying df file before loading it to Progress database and starting the migration.
CAUSE:
Data Definition file (df) was manually modified and some tables have information
for the _file record creation containing phrase QUALIFIER with the value "*".
Example:
ADD TABLE "sometable"
AREA "Schema Area"
DESCRIPTION "This is the sample table definition."
DUMP-NAME "sometabl"
QUALIFIER "*"
FIX:
Remove all unnecessary information from the df file prior to loading it into the Progress database. Look for the lines containing text FILE-MISC and QUALIFIER and
then remove them from your data definition file.