🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.oracle.misc
Article #93

Re: Schema Script Generation Tool?

#93
From: SFI
Date: Tue, 26 Jan 1999 00:00
33 lines
2234 bytes
You can use SQL-Programmer with Oracle as well as with your Microsoft SQL
Server to generate any DDL you want, from the same SQL-Programmer session.

Look at http://www.sfi-software.com for details.

"Best Integrated SQL Development Environment"
PC Week Labs.
http://www.sfi-software.com/pr29.htm

John,
SFI

"Chris Totten" wrote in message ...
>Does anyone know of a way to automatically generate the "CREATE TABLE" and
>"CREATE INDEX" commands from an Oracle database? We use SQL-Server 6.5 for
>development and it has a facility to "Generate Scripts..." from a
>collection of objects - we need something similar under Oracle.
>
>Is there a tool that either comes with the engine (like DBSCHEMA on
>INFORMIX) or something that we can download to do the job?
>
>Alternatively is there a way to convert the output of DESCRIBE to provide
>the same script?
>
>We need this to reverse engineer an Oracle database without actually
>having an ODBC connection to the database in question.
>
>If you can help in any way please mail me at mailto:chris@task.co.uk - I
>sometimes miss posts on UseNet...
>
>All the best,
>
>//chris
Technical Details
Message-ID: <78kqsi$sbo$1@news.igs.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <F5z6xq.7K@cix.compulink.co.uk>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f695,14eb1b54245a6ad0,start
X-Google-Attributes: gid10f695,public
X-Google-Thread: f99a8,14eb1b54245a6ad0,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: fa4f9,b5a9680b88f07b08
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f5464,14eb1b54245a6ad0,start
X-Google-Attributes: gidf5464,public
X-Google-Thread: 104bdf,14eb1b54245a6ad0,start
X-Google-Attributes: gid104bdf,public
From: "SFI" <info@sfi-software.com>
Subject: Re: Schema Script Generation Tool?
Date: 1999/01/26
Message-ID: <78kqsi$sbo$1@news.igs.net>
X-Deja-AN: 437157144
References: <F5z6xq.7K@cix.compulink.co.uk>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: abuse@igs.net
X-Trace: news.igs.net 917368530 29048 206.248.21.242 (26 Jan 1999 16:35:30 GMT)
Organization: SFI
Keywords: SFI SQL FAUST
NNTP-Posting-Date: 26 Jan 1999 16:35:30 GMT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools,han.comp.database,microsoft.public.sqlserver.server