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.
- Windows 8/7/XP/Vista
- Pentium II CPU
- 512 MB RAM
||Free to try, $999.00 to buy|
Key Features of ApexSQL Audit:
- 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.
| RELATED SOFTWARE DOWNLOADS FOR APEXSQL AUDIT |
- Business Applications Architect
is a solution that offers much more than a unified platform for your end-user database applications.
- MySQL for Outlook Express
allows users to Download, Upload and Report E-mails instantly with a MySQL Database
- ApexSQL Diff
s a high speed database comparison tool that analyzes the differences in tables, proc
- ApexSQL Doc
is a powerful tool to document your sql server database into Compiled Help or HTML documentation.
- ApexSQL Edit
is a powerful IDE especially designed for advanced SQL Server developers including integration with source control, Intelliprompt..
- ApexSQL Log
can audit SQL Server and Recover Lost Data that analyzes SQL Server's own transaction log to display information.
- ApexSQL Report
is a data driven, web reporting solution for Microsoft SQL Server.
- ApexSQL Script
is a SQL tool that converts Databases into scripts, .net EXE's, deployment packages or into source control.
- ApexSQL Clean
Apex SQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures.
program to migrate Microsoft SQL databases to Oracle server
convert MySQL databases into Microsoft Access format
It is a program to convert MS Excel spreadsheets into MS SQL databases.