Re: Creating scripts

See what PC Week thinks of SQLNavigator/Quest and Platinum... TOAD is far behind.
http://www.zdnet.com/pcweek/stories/news/0,4153,363685,00.html

Good stuff in there for sure!

> -----Original Message-----
> From: Michael Krolewski [SMTP:vandra_at_u.washington.edu]
> Posted At: Saturday, October 24, 1998 5:41 PM
> Posted To: misc
> Conversation: Creating scripts
> Subject: Re: Creating scripts
>
> There are no simple ways of getting all the tables and columns. It is
> possible to write SQL to extract in an intelligent manner this
> information
> but few of us have bothered to write or use it.
>
> A good alternative is TechnoSolution SQLNavigator (about $600) which
> is a high end developer front end to Oracle. It has an extract DLL
> function
> embedded in it.
>
> A second choice is TOAD. (Tool for Oracle Application Development , i
> think).
> It is freeware
> available at www.toadsoft.com. It has many of these features. If all
> else fails
> you can open each
> table and copy / paste the ifnormation out of the windows.
>
> Happy hunting.
>
> Mike Krolewski
>
> Bret wrote:
>
> > We have a client with an Oracle 7 database. I do not have access to
> the
> > manuals, so forgive me if this question is very basic. I need to
> know if
> > the following is possible, and generally how it is done so that I
> can
> > present a solution to my team.
> >
> > Our client uses an Oracle database, and we need to build their
> table/index
> > structure on our in-house, non-Oracle database. I need to know a
> command
> > from Oracle that would produce a text script of all of a particular
> user's
> > tables, indexes, stored procedures, triggers, etc, so that I can
> create the
> > same structure in our database by running the script. I would also
> like to
> > dump their data into a text file for importing into our database.
> >
> > Does the enterprise manager provide these functions? What about
> command
> > line utilities? I appreciate any info provided.
> >
> > Bret
>
>
Received on Fri Oct 30 1998 - 17:31:02 CST