Add tables to in use DB?

[cesida]

Hi...

With Progress Entreprise 9.1B running on Win NT 4.0, is possible to add tables in a DB which is in use?
I read something about one parameter (-z) that allow it.
But, which are the risks?

Something like that really would help me with systems running 24 hours at day.

Any reply will be welcome.

Juan M.

 

[dkellgren]

You cannot change the schema of a db that is in use.

We just implimented a system the limits the downtime, but isn't truely 24 hour.

We have a mirror of our live DB called DEV. We develop against DEV all day and when necessary, run an incremental DF to update live with. We've written a series of scripts that help to automate the process - which happens each morning between 3-3:30am.

This method also allows us to use a primitive release and control system (just using .bat files and some backup directories).

This is a SEVER limitation of Progress. I wish I had more info on the risks of using the -z too!

 

[cesida]

Thank you, dkellgren

You told me just what I expect, but I had a little hope...

It should be possible to add tables that nobody use yet, although the DB is in use. I don't understand the reason of that limitation.

What about add indexes?
this implies to change the schema too?

 

[dkellgren]

Yep... it sure does. You can't add/edit/delete indexes, tables, fields, or trigger code. And I agree - it's a huge limitation. As good as Progress is, you'd think they'd "fix" that!

Especially since (as others have indicated on this board) you can do it in other DB products - like Oracle.

later!