Milan,

> --- Martijn Tonies wrote:
> > > However all our updates happen automatically without any tool.
> [...]
> > > I created a new column and moved the data, dropped the current
> > > column and replaced with a new column.
> > This can be done if there are no references to the column, but not
> > otherwise.
>
> Well, you can always drop all the dependencies, do the change and
> recreate them. In FlameRobin it's as easy as one click on "Generate
> Rebuild Script" on table's properties page. I wonder why no commercial
> tool has this useful option? ;)

This is rubbish, there are tools that have this.

> And for those who like to have updates automated, FlameRobin logs
> everything into SQL files that are used later to update the database.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com