As an IT manager can you recall the last system outage caused by a database schema change? Do you sometimes consider how to better serve project staff with tools to reduce the inevitable disruption?
If not, then congratulations are in order because your change control and your remediation procedures are excellent!
Unfortunately, most of us can recall recent problems stemming from database changes.
... And every time it happens, we reassess how changes that are poorly documented or poorly communicated can be destructive.
Typically, our DBAs support dozens of schemas, each with several database environments and sometimes across more than one RDBMS. They build, they share, and they deploy database object creates, alters and drops to stay current with application upgrades and patches. Often up to thousands of DDL changes per month.
And how to prepare project teams for upgrading downstream systems?
DBAs manually document and share schema changes – they post to email distribution lists to make sure that project teams have ample time to update their code.
Unfortunately, the occasional change will “fall through the cracks”, causing some process to fail, some error or performance problem, or worse, complete system outage. Ouch!
Our post-mortem reviews often show that the change was not fully documented or was missed entirely by downstream project teams.
Sometimes DBAs will try to solve this problem with database triggers that capture schema change events. But triggers impact performance and require manual preparation to filter and make sense of change. Also, it is rare that the trigger solution can automate email alerts.
We have learned to accept the myth that a fluid database schema will occasionally lead to system failures.
Until now. Now we have SchemaTrack – a full-stack software solution employing a meta-capture job to detect, record and share create, alter and drop operations on tables, views, indexes and constraints.
Meta-capture invokes high performance queries on system views to do this work for Oracle, SQL Server and DB2 databases across the enterprise.
SchemaTrack guarantees project teams are always one or two clicks away from planned, deployed and historic database changes.
A tool that accelerates respect between IT leadership, DBAs and programming staff, SchemaTrack brings new heights to project team spirit, cohesiveness and productivity.
Not sure about this? Ask any programmer what it feels like to chase a bug or a performance issue for half the day only to find the root cause to be a schema change they were not made aware of. Ouch!
Sample for yourself how your technical staff will use a comprehensive view of planned, deployed and historic schema changes. Without any registration or delay, click Live Demo for our Amazon cloud (AWS) release of SchemaTrack. Instantly see how your own project teams will gain confidence and appreciation in the new “DBA transparency platform”.