Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Good Tool for Schema Generation?

Re: Good Tool for Schema Generation?

From: Vikas Gautam <gautam_at_sequent.com>
Date: 1997/08/11
Message-ID: <5snuis$or3@scel.sequent.com>#1/1

There is a good third party tool that we have used from LOGICWORKS. We actually use two if their products viz. ERWIN and TESTBYTES.

With the first, you can do 95% of your schema related design and with the second you can load data into the database. TESTBYTES was pretty cool as we created SQL*LOADER data files that we then directly loaded into the database. If yor goal is to have insert entries, a simple awk can do the stuff. A third option that we used for some table was to directly load the table from the software with no temporary files.

You need ODBC with TESTBYTEs.

Hope this helps.

Vikas

In article <01bca4c0$541b90a0$5eeb2399_at_jharby>, Darby Crash <nospam_at_satan.com> wrote:
>Oracle Designer/2000 will definitely do this.
>
>venkata terala <venkata_at_inetnow.net> wrote in article
><33D0EAF8.6202_at_inetnow.net>...
>> Hi! I am looking for a tool that can generate the whole schema from an
>> existing database (tables, indexes, stored programs, triggers ...). I
>> should be able to select the objects that I want generated. Does anyone
>> know of a good third party tool that can do the above ? It would be
>> nice if it could also generate INSERT statements with data. The scripts
>> generated will be used for install purposes.
>> Thank you all in advance
>>
>> Venkat
>> venkata_at_inetnow.net
>>

-- 
----------------------------------
Vikas Gautam ,
Sequent Computer Systems,
847-318-0050
Received on Mon Aug 11 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US