ApexSQL Audit

ApexSQL Audit is an Audit Trail generation and reporting tool for Microsoft SQL Server 7.0, 2000 and 2005 Databases. The tool is both configurable and scriptable allowing for easily modifying auditing architectures or even creating new ones with the full feature trigger template IDE.

ApexSQL Audit generates server side triggers that tracks all Insert, Update and Delete statements. It includes powerful reporting utilities that can extract the audit data into meaningful reports. Tons of other value added functionality is included like trigger and data management, transaction Undo, Audit Data grouping analysis and more.

Download Trial 7.30 MB           Buy Now $ 999.00 USD

Software Information		System Requirements
Version:	2013.01	Windows 8/7/XP/Vista Pentium II CPU 512 MB RAM
License:	Free to try, $999.00 to buy
File Size:	7.30 MB
Screenshot :	View Screenshot
Rating :

• 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.
• Database schema changes tracking ?Project files in ApexSQL Audit save database schema information and can be used to detect changes to the schema.
• 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.