Just run a script into your database that will change the metadata in the
schema according to your changes. No need to drop the database and rebuild
it unless you have DROP'd any columns from tables, or entire tables. SQL
gives you ALTER statements to allow you to do this automatically, and CREATE
PROCEDURE will take care of adding any new stored procedures you require.

Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org

> -----Original Message-----
> From: Muthu Annamalai [mailto:pearlamerica@...]
> Sent: Saturday, February 26, 2005 10:05 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Data Extract
>
>
>
> After my application is shipped to customers, if I change the
> database file, let us say added some new stored procedures , how can
> I update customer db.
>
> Practically I have to extract data from customer db and insert into
> new db,if it is so, can anyone give some idea how to do data extract
> in a better way.
>
> Regards,
>
> Muthu Annamalai
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>