Kbase P115367: What is the order of the objects dumped by the sqlschema tool ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/25/2006 |
|
Status: Unverified
GOAL:
What is the order of the objects dumped by the sqlschema tool ?
GOAL:
Can I change the order of the objects dumped by the sqlschema tool ?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
The Sqlschema tool dumps all the contents of the structure in alphabetical order, this can not be modified and may cause some issues for objects which have dependencies in objects that are not yet created by the time the tool tries to load some particular object.
It is necessary to verify that the objects are created in a precedence in which the top objects in the script do not have dependencies of objects that come after in the script, to fix this issue some manual edition of the generated SQL script may need to be applied to change the order of the objects, making sure the views that require the existence of an specific object are created at the end in the file .