I think what he wants is generate a script from a database like we do with mssql server for instance.
I know a way using a case too like power desing or case studio (www.casestudio.com). may it helps you , bit i hope firebird has it's own way to do it.

----- Original Message -----
From: Alexander V.Nevsky
To: firebird-support@yahoogroups.com
Sent: Wednesday, January 28, 2004 3:47 PM
Subject: [firebird-support] Re: Creating database through a script and later updating it


--- In firebird-support@yahoogroups.com, Venus Software Operations
<venussoftop@m...> wrote:
> Hi all
>
> For eg. I have created a FireBird database on the development
machine. Now
> I want to deploy it for the first time to a client machine. How is
it
> possible to recreate the database by a junior support tech person on
the
> clients machine.

Make backup and send it to this person together with BAT file
containing proper gbak call to restore. If you don't want to send
data, make metadata-only backup.

> For eg. 2 Now I have modified the data structures on the
development
> machine. Now I want to change the structures on the clients
> machine. Please note there are no formal changes track record, so I
just
> have to have the current data structures and apply a script at the
clients
> site onto the existing FireBird database and it should come upto
speed
> without loosing the data.

Don't understand clearly. You have debugged script which bring
target database structure to source one? Send it together with BAT
file containing proper isql call. Or you are interested how to build
this script if you don't remember what changes you did? If so, always
have structure of client's database at hand and look at
http://www.clevercomponents.com/products/dbcomparer/dbcomparer.asp

Best regards,
Alexander




------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]