Everardo Cunha
Atlantis Informatica, Ltd.
Tim Weisbrod
inphonic
Leo Stezano
Decision Architects
Cambridge, MA
Michael Bunger
"Thanks for the feedback Brian - I have liked the UI and support for your product the best, I should be parting with my cash very soon.."
Patrick McCarthy
Developer
JDA Software Group, Inc
Martin Schwier
Proj. Manager
WDT Datentechnik
GmbH, Germany
Add instant audit
trails to any SQL Database
Track
Inserts, Updates, Deletes by user, machine, date, application and more
integrating the logic directly into your application
Fully customizable and extensible architecture. Change
trigger templates from directly within the
built
in IDE, modify architectures (fast reporting, distributed
audit log tables, etc
Powerful reporting module as well as
exports to Excel, CSV.
Per Client licensing -
audit unlimited
servers.
Whether you are relatively new to SQL Server and just need an easy to use utility or you are an advanced user who is comfortable creating your own Audit architecture from scratch - ApexSQL Audit is a great SQL Server auditing solution.
We also offer a stand alone Audit Viewer which is sold separately.
|
Product Information
|
|
- [New] Audit data can be stored in a database separate from the audit database.
- [New] Custom filters for reports allow you the flexibility to customize generated reports from log storage tables.
- [New] Lookups and Watches allow you to Log not just the modified data but any related data within the table or the database.
- [New] ApexSQL Audit can now automatically detect whether changes in table definitions may have damaged triggers and automatically repair them.
- [New] SQL 2005 support.
- Scriptable, customizable trigger templates that allow you to modify triggers.
- Profiles automatically save your field and audit selections from your last session. No more tedious reconstruction of Audit plan.
- Trigger management module - delete, enable / disable view triggers in an easy to use interface.
- Incredibly functional template editor enables you to modify triggers or create your own using Microsoft VBScript or JScript and leveraging the full power of Microsoft Script parser and debugger.
- Template editor offers intellisense support for the Audit object model and includes a built in property page.
- Powerful data management module for deleting audit data. Functionality includes the ability to create, save and schedule Data Transformation Jobs. The DTS job manager also allows for editing and deleting existing jobs.
- Amazingly comprehensive Help file includes step by step articles, full object model, examples and architects notes.
- Real Reports - audit reports that allow you to print and export preformatted HTML.
- Both Standard and Aggregate Reporting supported - reports can be output to Excel, text, HTML and printer.
- An Audit data management grid allows you to filter, sort and group Audit data for quick and powerful analysis.
- Easily manage Audit architectures by editing scripts from within the application, installing architecture, removing architecture and running an analysis on the integrity of the current database's architecture.
- Ability to view triggers directly from interface and even enable / disable them directly from the main form.
- The Table list indicates which tables are currently audited.
- Quick controls allow selection of all tables, all field and all audit options or any combination of these.
- View object DDL directly from the application.
- Write triggers directly to the database, automatically call SQL Server Query-Analyzer and load in the script file or use default script editor.
"I've been a huge fan of the SQLAudit which I've already put into production. That single application has saved me countless hours of programming to help get in compliance with some data auditing requirements."
Walt Krzystek
Director of Operations
Matrix Imaging"... I also wanted to say thanks for such a great product and for being so responsive!"
Richard Dablo
Project Manager
Quest Diagnostics Clinical Trials
"First let me say we are very impressed with ApexSQL Audit Tool, it was not only the fastest but also the easiest to use out of the six audit tools tested. We also hit some errors with other Audit products."
Paul Ohlemacher
Developer
Execupay"ApexSQL Audit has been a life saver for me. No longer can our business clients blame the system or my IT staff when errors appear in our data. Thanks to ApexSQL Audit, we can now track 'when' and 'who' made the change and if needed restore old data. ApexSQL Audit has paid for itself in it's [sic] first week of use."
Andy Zecha
Director of Database Operations
HubX.net"I have been using ApexSQL Audit for over a year now and find it to be a great tool. ApexSQL Audit is great at capturing all of the information (user, date, time, old value, new value, etc) required by my application. The best part about ApexSQL Audit is that while being very easy to implement out of the box, it is also highly customizable. We have full access to each trigger and script and can customize them easily if the application requires."
Kris Gustafson
Director, Interactive Technologies
ICON Clinical Research




















