You can compare the two databases using Database Workbench and it will
generate a script that acts against the system tables, to allow things
such as altering views. Of course, have everyone disconnect before
altering the schema.

-----Original Message-----
From: Firebird-Java@yahoogroups.com
[mailto:Firebird-Java@yahoogroups.com] On Behalf Of rwilcom
Sent: Friday, September 09, 2005 8:42 AM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Database Schema Updates

Opinions needed - although this is not a Java/JDBC question - I thought
I would post it here since I am familiar with this group (and hey, I
like you people better!).

I have to update an existing Firebird database schema without disturbing
the current data in the database. The schema updates are additions to
tables and new tables. My two options are to create alter table scripts
and apply them to the existng database OR offload the data to
re-loadable scripts and completely update the database definition (then
re-load the data).

Anyone had to make this decision before? If so, any opinions on either
case would be great (or another approach). If you have tried the
offload approach, how did you create the re-loadable script? - does the
Firebird 'gbak' utility support this in any way (or another utility)?

Thanks for any help!
Ron




------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet
Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links