Article View: comp.databases.oracle.misc
Article #93Re: Schema Script Generation Tool?
From: SFI
Date: Tue, 26 Jan 1999 00:00
Date: Tue, 26 Jan 1999 00:00
33 lines
2234 bytes
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-mailReferences:
<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