Heyas,

Here's a screenie of how it looks:

 

Selecting "Editor as Script" opens one window for each object (hint: 83 Objects selected :)). No other options avaiable...

regards
Marc

--- In toadmysql@yahoogroups.com, Dwight Fowler <dwight.fowler@...> wrote:
>
> Make sure that you are in Treelist mode.
>
> Select all the objects by clicking on the first one, then shift-click on the last one
>
> Right click on selected items.
>
>
>
>
>
> ________________________________
> From: toadmysql@yahoogroups.com [mailto:toadmysql@yahoogroups.com] On Behalf Of marc.rink
> Sent: Thursday, November 20, 2008 5:04 AM
> To: toadmysql@yahoogroups.com
> Subject: [toadmysql] Re: Generate ddl script to re-create all objects in database
>
>
> Hi!
>
> i did not get this to work: Step 8) "Right click on selected items"
> only shows a "Create..."(for Object-List filter) Menue and a submenu
> for each Object type ("Function (5)", "Procedure (2)", ...). If i go
> to any of the object related submenu and select "Send To..." and then
> "Editor as script..." i get one window for each object, but some of
> the windows are plain empty (~50%).
> Additionally, i can't use the "Save All" function from the "File" menu
> to save them all at once, they appear to have the "already saved" flag
> (no * in editor name).
>
> regards
> Marc
>
> --- In toadmysql@yahoogroups.com<mailto:toadmysql%40yahoogroups.com>, Dwight Fowler dwight.fowler@ wrote:
> >
> > Al,
> >
> > There is an easier way, but it's not obvious. Here are the steps:
> >
> > 1) Open Object Explorer
> > 2) Set Object Explorer to Tree List (VERY IMPORTANT):
> > a) right click on empty space in Object Explorer
> > b) select Options|Treelist in context menu.
> > 3) Navigate to the Object List.
> > 4) Right mouse click on empty space in Object List and select Create...
> > 5) Create a new list:
> > a) add name for list
> > b) add definition for each object that you'd like in your list:
> tables, views, indexes, procs, funcs, etc.
> > 6) Open new list
> > 7) Select all items in list
> > 8) Right click on selected items
> > 9) Select Generate SQL|To Editor|Creation Script
> >
> > A new editor window should open and a sql script with DDL for all
> the objects in your list should be generated.
> >
> >
> >
> > Dwight
> >
> >
> > ________________________________
> > From: toadmysql@yahoogroups.com<mailto:toadmysql%40yahoogroups.com> [mailto:toadmysql@yahoogroups.com<mailto:toadmysql%40yahoogroups.com>]
> On Behalf Of Albert
> > Sent: Tuesday, November 18, 2008 5:38 PM
> > To: toadmysql@yahoogroups.com<mailto:toadmysql%40yahoogroups.com>
> > Subject: [toadmysql] Generate ddl script to re-create all objects in
> database
> >
> >
> > It seems like I have to use Object Search in order to generate a script
> > that I can then use to re-create the entire database structure, procs,
> > views etc. (no data). However, in Object Search I don't know how to
> > select 'All'. It's a bit cumbersome having to keep entering search
> > criteria and appending to the list until I have all the objects I
> > want. Is there an easier way to accomplish this?
> >
> > Thanks,
> > Al
> >
>