Consultor Eletrônico



Kbase P16902: Migrating the Progress database to MS SQL or ODBC compliant
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   21/03/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.