We make extensive changes to live SuperServer databases without any problems
(apart from the occasional challenge with a foreign key) and have been doing
so for many year in IB and now FB1.5. It may be relevant that our apps tend
to spread the transactions amongst a high number of functions so each is not
intensively used.

However we discovered that this was not possible in Classic Server since
everything a user touches is locked until they log out.

Regargs
Paul

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Woody
> Sent: 06 August 2007 18:43
> To: Firebird Support
> Subject: [firebird-support] DDL Question
>
> So far, I've always waited until all users are out of a
> system before applying metadata changes. However, there are
> times where I'm working on a new part of the system involving
> tables which the application is not yet using. At least, the
> application version that the users are using, anyway.
>
> Are there any dangers to doing metadata changes to tables
> which I know that no one is using except me? I haven't done
> it yet, because I don't want to risk the integrity of the
> live (users) database. But I would be interested to know if
> this is safe at all...
>
> Woody (TMW)
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>