Kbase P98570: How to handle schema holder when upgrading from V9 to OE?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/09/2008 |
|
Status: Verified
GOAL:
How to handle schema holder when upgrading from V9 to OE?
GOAL:
How do I migrate a V9 schema holder to OE?
GOAL:
What to do on shadow columns now OE uses upper function to support case insensitive indexes?
FACT(s) (Environment):
Oracle DataServer
Progress 9.x
OpenEdge 10.0x
FIX:
When migrating a V9 schema holder to V10, nothing specific to shadow columns needs to be done. You only need to dump and load the schema holder df into a V10 empty database. The data server code will use existing shadow columns if there are any and for new tables created in V10 and migrated to Oracle, the data server code will check to use upper function instead of shadow columns.