[This topic is migrated from our old forums. The original author name has been removed]
Hello, I'm trying to export a Sybase database to an SQL file. In the database browser I see the views in this order:
* CINTA_RELOPE_CORP_EOT
* CINTA_RELOPE_CORP_EYT
* CINTA_RELOPE_CORPORATE
The latter uses CINTA_RELOPE_CORP_EOT & CINTA_RELOPE_CORP_EYT, but when I open the DDL file the order is:
* CINTA_RELOPE_CORPORATE
* CINTA_RELOPE_CORP_EOT
* CINTA_RELOPE_CORP_EYT
So I can't import them in a new DB because when the importing process reach CINTA_RELOPE_CORPORATE it can't create it because the others aren't created yet.
Hi Eduardo,
You're right. The script creates the Views without consideration of dependencies between them. I have opened a ticket for this issue, but for now you need to manually rearrange the CREATE statements in the script before you execute it with the new database.
Best Regards,
Hans
a
anonymous
said
over 13 years ago
[This reply is migrated from our old forums. The original author name has been removed]
anonymous