db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vic Ricker <...@ricker.us>
Subject Re: Updating Embedded Derby Db
Date Thu, 25 May 2006 13:56:38 GMT
Would it be easier to just issue 'alter' and 'create table' commands on
the existing database instead of sending a new one?  For example, "Alter
table foo add column bar ..." and 'create table new_table_name ( ...'.

Carol Gloyd wrote:
>
> Hi,
>
>  
>
> I'm fairly new to Derby and am wondering if there is a way to update
> an embedded database programatically? By update, I mean adding new
> tables and adding columns to one or two of the existing tables.
>
>  
>
> Several months ago I wrote a stand-alone pricing/ordering application
> which was distributed on CD.  The client recently requested some
> changes which involve the schema changes mentioned above.  The app
> will be redistributed on CD once the changes are complete.
>
>  
>
> The problem: The updated database I will provide contains no data. 
> Customer A receives the updated application, but already has data in
> her current database, and cannot just overwrite with the "empty"
> updated database.  I need to create what amounts to a "1-click" method
> for the customer to update the database without losing any of the
> current data.  Is there existing code or other information that could
> help me with this?
>
>  
>
> Hope this makes sense!
>
>  
>
> Thanks,
>
> Carol
>

-- 
Vic Ricker
http://www.ricker.us/


Mime
View raw message