Subject Re: Best way to copy records from a FireBird DB table to another FireBird DB table
Author cornievs
Hi

I use the following solution. I use a tools like IB Expert to change the metadata and log the changes to a file. These changes I then save in different DB with a table with field that has the metachanges and a field with a version number. On application start up I check the version to that the programs requires and if required run the metadata changes on the customer Db.

Hope it helps

--- In firebird-support@yahoogroups.com, "RDS" <rdsc1964@...> wrote:
>
> Hello,
> I please need support on the above issue.
>
> EXPLAINATION
> I have deployed an application for which features have yet not been freezed. Hence my database keeps changing - mainly as addition of fields to tables, addition of tables, addition of stored procedures. Hence when i deploy new versions of my application, back up and restore will not work.
>
> Thanks and regards,
> Lt Col (Retd) RDS Chauhan
>