Start a new topic

Export views in bad order

[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.

[This reply is migrated from our old forums.]

Re: Export views in bad order
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
[This reply is migrated from our old forums. The original author name has been removed]

Re: Export views in bad order
Thanks Hangs.