Re: Generating SQL code for schema objects

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 2000/07/06
Message-ID: <8k2j0d$s2c$1@garnet.tc.umn.edu>#1/1

I have a cheezy script for this at http://www.sofbot.com/ ugly_DDL is the script which uses Oracle utilities exp, imp, and ksh and awk. It can be ported to NT with gawk and Cygnus tools.

There is a perl version listed in the OraMag tips and code. which uses Oracle exp, imp and perl to do about the same thing and can probably port to NT

Oracle marketing has seen it fit to create the Black Hole of data, only goes in, nothing comes out unless you buy a $50,000 Oracle Designer license.

ERWIN or some of the other RDBMS design tools will reverse engineer the database too. And have the advantage of translating to other RDBMS (like Sybase or Informix).

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.tc.umn.edu/~hause011


---------------------------------------------------------

Received on Thu Jul 06 2000 - 00:00:00 CDT