Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Good Tool for Schema Generation?
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-0050Received on Mon Aug 11 1997 - 00:00:00 CDT