You are wrong here Nic.
I regularly make changes to both Live and Dev Databases with no loss of data
and No Corruption. It is possible (but not common) to screw a database with
accidental
stupidity, (I know) but with a little care, you can change Meta data quite
safely.
You do it like this.
Drop All Users.
Drop SP's, Triggers, and Exceptions.
Alter Database
Create Exception, SP's and Triggers.
Test and Reconnect Users.
In other words, drop dependencies, then Alter DB, then create Dependencies.
It is essential to have well maintained Scripts for this, and good Data
Model Maintenance Disciplines..
/*************************************************************************/
If you DB is in trouble, just back it up and restore it. If it wont Back up,
run GFix. Re Run GFix until it is fixed or you give up.
Cheers,
Tony.
-----Original Message-----
From: Nic Wise <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Wednesday, 2 February 2000 21:40
Subject: Re: [DUG]: Interbase Error : What am I missing here??? (Interbase
Newbie)
> You're making me nervous. Here I am playing with 2 tables and you are
> suggesting things like the above (Linux v Windoze springs to mind). Does
not
> bode well for a production system. (This is 5.5, perhaps 5.6 is better??)
I thought I sent this before - sorry if i'm repeating myself.
I'd not expect to change ANYTHING but data on a live system - definatly not
add a trigger or procedure (ok, maybe a proc, or a view). I try and get my
data model (which includes triggers) right before too much of it gets
released.
> Tried that..... Doesn't like it.... Naturally the procedure has
> dependencies.......
thought that might be the case.
> As I am still playing I just killed off the whole table and then recreated
> it..... I think that some of the issues here are arising from the fact
that
> I am using SQL explorer and WISQL. I would like some GUI tool as a
fallback
> at some point for our people out in the field. If SQL Explorer does not
again, I have to ask why? why would tou change change structure of your db
once its released?????? Maybe I'm just anal when it comes to design - I try
not code cut code before I get the data model right, and I definatly dont
release it then change the DM.
> measure up (and the one you mentioned when I first raised the issue of
> interbase was also rather flaky) are there any others???
Other than that, you might want to talk to Wade (who's surname I can't
spell - someone got an email addy for him? mailto:[EMAIL PROTECTED]??) ,
wait and see what happens with IB6 (not too much better - tho it IS better)
when its opensourced, or write your own.
> Also did you read my post earlier about TIBEvents?? Any ideas on that???
Yup, I read it - sorry, I dont know - try the IB list (www.mers.com)
Nic
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
