|
|
Posted by Craig Kelly on 06/30/05 23:56
"Jay" <JazeMail@gmail.com> wrote:
> Many thanks for that Craig.
> We have 2 developers here (myself and one other) and we do all testing
> in the Dev environment before letting loose in the real world (99% of
> the time if the truth be told) my interest in LE was the ability to
> role back row level records (changes) rather than having to restore to
> a point in time thus potentially losing other bonafide changes.
> Jay
Jay,
You're welcome.
That's originally why we bought it as well (and the fact that we could look
at row-level changes: our system isn't fully audited). It works well for
fixing problems, but the farther away you get from the modification, the
less useful it is (obviously from a data integrity standpoint, but also
because of the sheer volume of transactions you have to pour through,
although there is a search function).
"99% of the time if the truth be told"
We have four actual developers and that's about how we handle it: but the 1%
was getting kinda hairy for us :)
One thing that I forgot: we have an automated build procedure that (among
other things) checks table schema and scripts stored procedures from test to
production. Running one of these builds results in about 2500 procs getting
re-scripted on production... It was quite a bit of fun the night of the
first build after installing Log Explorer when the first of about 5000
emails started rolling in (one for the DROP and one for the CREATE).
The problem here is that Log Explorer provides no documented interface to
automatically turn those emails on and off. Their technical people helped
us with the necessary changes so our steps look like:
- Delete specific rows from a table in the Lumigent database
- Fire off a Log Explorer extended procedure to notify the engine things
have changed (named xp_LEServer_TraceConfigure)
- Run the rest of the automated build
- Re-insert the deleted rows
- Call xp_LEServer_TraceConfigure again
This didn't bother us but some might consider it a PITA, especially if you
aren't that concerned with the emails in the first place (although you can
just turn them off permanently).
Craig
Navigation:
[Reply to this message]
|