Updating a database

Hi all,

This problem is not indirectly related to VB only because my application is
written in VB6, whilst the backend is an Access database. The database is
also versioned, ie. has a table 'id' with a column 'version'

I have the following scenario:
User A and User B install first version of the application. Version 1.0
I do changes to the app and the database (add fields, change queries,
etc...). Version 1.1
User A updates to Version 1.1
I do changes to the app and the database (add fields, change queries,
etc...). Version 1.2
User A updates to Version 1.2
User B updates to Version 1.2 from Version 1.0

Updates/patches will be downloaded for the internet or emailed. Updating the
application is easy with InstallShield.

But how can I implement a method to make updating a database from version x
to version y as easy as possible? Are there standard patch methods used or
do people develop their own?

Thanks,
Ivan


.

Relevant Pages

  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • Re: The right database for the job?
    ... Note that "many updates ... > the programmer that have to fix somebody elses code and/or database ... > devices under its control, it connects to a central "DB server" program ...
    (comp.databases)
  • Re: A different definition of MINUS, Part 3
    ... can actually be the value of the database at any set point in time. ... updates, on the other hand, assert which possible value for the ... neither the algebra nor the calculus are sufficient when it comes to ... To extend the analogy to view updates, we also have an input delta ...
    (comp.databases.theory)
  • Re: Disk transfers
    ... database software rather than in the application itself) is to capture the change in a relatively small update record in a log - which can be supported effectively in a relatively small amount of NVRAM if performance is important, rather than throwing GB of NVRAM at a generic disk write-back cache, and which in any event can effectively batch many such updates into a single log write if they occur very close to each other - and then later perform the eventual on-disk structural updates lazily, in the background, and possibly in bulk. ... though I'm not sure how the latter would vary all that much (unless you're just referring to the difference between disk and NVRAM performance). ...
    (comp.arch)