Subject Re: [firebird-support] How to update a data base
Author Lester Caine
W O wrote:
> Hello everybody
>
> My client has a database, I have the same database in another computer,
> several miles away. Later I do some change in my database (for example,
> adding a field to a table).
>
> Now, I want that both databases be equal, identical metadata. His database
> is in a hard disk, I had copied my database in a pen-drive.
>
> How can I do that? How can I update his database structure?

I use flamerobin for maintenance, and copy the SQL segments that are commited to
make the changes into an 'upgrade script' which I can then apply to other copies
of the same database.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php