Subject Re: [firebird-support] Re: Copy Table in store procedure
Author Helen Borrie
At 08:24 PM 11/01/2012, you wrote:
>How can I Prepare a suite of scripts? Is there any example script?

Create your own, using isql -extract server:dbalias > /filepath myscript.sql -user sysdba -password dbapwd8 > /filepath myscript.sql

Then you can open myscript.sql in a good text editor, adding comments, etc., changing statements if you need to, and start splitting it into smaller scripts. You link the scripts by adding an input /filepath nextfileN.sql to the end of sub-scripts that you want to execute automatically in the right sequence (different names for each nextfileN).

Did you know that you can use gbak -m to create a backup that is metadata only? When you restore that, it is a new, empty database. It's probably not what you want, though, if it is only tables you are renewing.

Read up on isql in the IB6.0 Operations Guide.