PRODUCT INFO
SEE ALSO
LOCALIZED DATASHEETS
Why ApexSQL?
To See the Top Reasons to Buy Apex SQL Software tools: Click
Here.
ApexSQL Univ Studio
$1,999
All ApexSQL Tools with 1 yr Maint and all New tools Free for 1 yr.
Learn More
FREE
SQL Tools
FREE
ApexSQL Tools and Add-ins. Learn More Killer Discounts
Unbeatable Killer Upgrades and Discounts.
Learn More
ApexSQL Gear
Click Here for our ApexSQL Gear Store.
SUCCESS STORIES
Lee Davies
Software engineer
Occam direct marketing
www.occam-dm.com
Martin Schwier
Proj. Manager
WDT Datentechnik
GmbH, Germany
Paul Barbin
DBA
Lewis, Inc.
Latest Version: 2008.01
Audit SQL Server Databases
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 User licensing - audit unlimited servers
We also offer a stand alone Audit Viewer which is sold separately.
|
Product Information
|
|
 |
Screen shot gallery |
)
)
)
)
)
)
)
){kind=link}
- [New] MS SQL 2008 support; also supports MS SQL 2000 and MS SQL 2005
- Audit data can be stored in a database separate from the audit database.
- Custom filters for reports allow you the flexibility to customize generated reports from log storage tables.
- Lookups and Watches allow you to Log not just the modified data but any related data within the table or the database.
- ApexSQL Audit can now automatically detect whether changes in table definitions may have damaged triggers and automatically repair them.
- 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 have been using APEX for about 3 years now, primarily for the audit tool, but all of the other tools are great too!"
John Goad
Sr. Solutions Architect
Affinia Group Inc."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