Updating local database Schema

Topics: Updater Application Block
Sep 7, 2005 at 8:42 AM
originally posted by: lottoman2000

Hello All,

Does anyone know what is the best practice for updating database schema? Is it possible to do it using UAB?

Thanks
Oct 26, 2005 at 6:09 AM
originally posted by: RajAlan

You could download the sql file containing the schema changes. Write an Activation processor that would run this sql file against the specified database.
Oct 27, 2005 at 12:25 AM
originally posted by: puy0

As RajAlan said, it can be done, but take care if users are on the database, they can lock what you want to update.

One solution is to try to set the database in "single user mode" before updating it.
And retry until everybody has gone...