Schema scripting - file per object - dependency order

[jerne...@gmail.com]

Hi,

I've been evaluation db solo and it almost fits my needs. I need to
produce ddl file per object. But I also need a "master" file, which
calls all files in the right dependency order.

Is that possible with db solo?

[DB Solo]

That's not currently possible. You have two choices a) one file with
all the objects in the dependency order or b) multiple files with no
specified order.
You could maybe generate both, then try to create the master file from
the single file using 'grep' and trying to match the pattern in the
header section for each object.

Marko

[jerne...@gmail.com]

One file for all the objects is ok (I could extract schema twice -
once for versioning and once for actual scripting), but it seems
dependencies are not handeled right for my schema. For example, a
trigger is generated before the table (and of course trigger creation
fails).
The database is oracle 11g. I have selected to keep the right
dependency order. Am I missing something?

Thanks

On 11 maj, 00:44, DB Solo <mhant...@gmail.com> wrote:
> That's not currently possible. You have two choices a) one file with
> all the objects in the dependency order or b) multiple files with no
> specified order.
> You could maybe generate both, then try to create the master file from
> the single file using 'grep' and trying to match the pattern in the
> header section for each object.
>
> Marko
>

[Marko Hantula]

Could you send an example that would demonstrate the problem?

Marko

DB Solo - The SQL Query Tool
www.dbsolo.com

[DB Solo]

Actually there was a problem with the dependency sorting, which should
hopefully be fixed now. Please download the latest from
dbsolo.com/preview and let me know how it works.

Marko