RE: [Squirrel-sql-users] SQL Script plugin question

[Colin B. <Col...@as...>]

You can click on the first table in the object tree, <shift>click on the
last table, right click and select "Create Table Script" which will generate
the "CREATE TABLE" scripts for all the selected tables. This works
reasonably well for a single schema/catalog but if you have multiple
schemas/catalogs it can be a bit of a pain.

Col

-----Original Message-----
From: John Zoetebier [mailto:joh...@tr...]
Sent: Monday, 26 May 2003 12:52
To: Colin Bell
Subject: Re: [Squirrel-sql-users] SQL Script plugin question


Colin Bell wrote:

>There is a hierarchical menu "Scripts" on the "Session" menu. This has the
>options "Load Script" and "Save Script". These options will load an SQL
>script from a text file into the SQL entry area and save the contents of
the
>SQL entry area to a text file.
>
Thanks Colin,
I found it.
Is this function on table level only ?
Or is there a function that generates the data SQL for the whole datase ?
Something similar to what phpMyAdmin does for MySQL databases.
That function would be realy helpfull as it allows me to instantly 
backup and restore a database in test environment.

-- 
John Zoetebier
Web site: http://www.transparent.co.nz


>
>Col
>
>-----Original Message-----
>From: John Zoetebier [mailto:joh...@tr...]
>Sent: Sunday, 25 May 2003 12:49
>To: squ...@li...
>Subject: [Squirrel-sql-users] SQL Script plugin question
>
>
>I have installed the SQL script plugin.
>When I create a script the output is sent to the SQL window.
>I would expect a dialog to enter filename.
>Do I have to copy and paste the output into a file manually ?
>
>  
>