Re: Schema installation tools

"Pasi Parkkonen" <pasi_at_eigenvalue.com> wrote in news:d1Zc9.956$19.395345_at_reader1.news.jippii.net:

> Hi!
>
> I'm wondering what tools you use for generating scripts
> from your database. I need to do customer installations
> into bigger Oracle servers, so I will need good scripts.
>
> I have used Toad & my own script generators
> (SQL*Plus scripts) but they both have problems..
> Toad makes errors and well.. SQL*Plus ain't perfect... ;)
>
> So - what do you use for getting *everything* into script form:
> -Tables
> -Views
> -Table constraints (+ references)
> -Table data (in correct order when references present!)
> -Sequences (set to correct value!)
> -Indexes
> -Synonyms
> -Procedures & Functions
> -Triggers
>
> I'm not looking for the most "heavy" software,
> lightweight tool is cool :)
>
> Also - ER capabilities plus, not must.
>
>
> Thanks,
> Pasi Parkkonen
>
>

I've been using SQL Navigator (by Quest Software) for years and it does everything you're asking for, Received on Fri Nov 22 2002 - 02:29:00 CET