PRSQL9103005: Cannot Load Case Sensitive DB Into Insensitive

ID Number: Q70825

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9103005

SYMPTOMS

After running "DBCC checkdb" on a recently loaded database, there

are errors stating the table is corrupt and the keys should be in

descending order.

CAUSE

Loading a case sensitive database into an insensitive database or

vice versa will corrupt the indexes in the database.

RESOLUTION

BCP out the data, create the tables on the sensitive database,

and BCP the data into the new database.