ApexSQL Audit

Apex SQL Audit proves a comprehensive, enterprise level active data auditing tool for Microsoft® SQL Server© 7 or 2000 Database auditing unmatched on the market today.    

This Apex SQL Auditing tool is both configurable and scriptable and ships with the power of Microsoft VBScript parser.  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 and modifying trigger templates - Apex SQL Audit is the perfect SQL Server© active auditing solution solution for you.

[New] ASP web reporting front end with full source code for standard and aggregate audit reports. 

[New] Database transaction UNDO - this powerful new feature allows for the reversal of database operations including inserts, updates and deletes.  This powerful module is incredibly robust - it will produce a pre-undo report to explain the impact of changes and a post-undo report indicating any problems.   This process even allows for a complete rollback of all undo operations pending the results of the post-undo report.

Coming Soon in version 3.0 ...    

• Completely redesigned interface
• Separate client application for Audit reporting
• Batch / Command line interface
• Optimize trigger template and architecture for SQL2K only
• Tons more smaller features
• Faster performance of application and trigger script processing
• Improved help file
• Improved UNDO

Features

• FREE web based (ASP and ASP.NET) reporting client WITH FULL SOURCE CODE.  The source code is available to registered customers via Customer Center. 
• Scriptable, customizable trigger templates that allow you to modify triggers - no more hard coded, take it or leave it audit architectures.  
• 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.

How does Apex SQL Audit compare?

• Apex SQL Audit provides the BEST auditing architecture.  We searched far and wide for the best SQL Architect in the world to design the default Apex SQL Architecture and he delivered.  It is fast, compact and logical.  
• Unlike more than one competing product, we DON'T store Audit data in XML format which violates nearly every rule of database design and increases the size of auditing data by more than a factor of 10.  Don't these vendors understand you can easily extract this audit data into XML via SQL, ADO and other means saving yourself tons of storage space?
• Flexible - we have separated the logic from the application meaning that you aren't locked into a hard-coded audit architecture like all of the other trigger based auditing products.  What if you want to modify your architecture?  This is easy with Apex SQL Audit - and we have SQL Architects available to help you do this.  A complete architecture is simply one XML file which you can just open and install with Apex SQL Audit.
• Reporting - some products offer reports, some offer exports, some offer grid based manipulation and grouping.  Apex SQL Audit offers all of this in one package.  Update and now with the free ASP.NET web reporting client you can allow all of your users remote access to your audit reporting data.  Unlike competitors who offer "audit viewers" for a per license fee of up to $100 per user - our ASP.NET client is free.
• No encrypted objects or hidden operations.  Other products will surreptitiously write objects to your database without you knowing it.  Apex SQL Audit's architecture is fully exposed for the customer to see.
• No destructive registration enforcement where triggers cause your database to self destruct once the registration period is over.
• The most sophisticated data management module - data can be deleted immediately or a DTS job can be created and scheduled with a powerful scheduling interface.
• Per developer - not per server licensing.  If you have 1 server or 20 the price is the same.  Apex SQL sells software to developers not servers.

Audit Reporting client

ASP web reporting front end with full source code for standard and aggregate audit reports. 

Custom Architectures

We have expert SQL Architects on staff to custom design an Audit architecture to meet your needs. 

What customers are saying ...

Awards

Customer Comment

"I congratulate you on the decision and the approach of free upgrades for life as it is a rare opportunity to see that these days, when most other software companies want more and more money for the things we as users already paid for. I think that if you believe in your product it will speak for itself"

Vilko Poznovia
Database Administrator
Silver Chain
Perth, Western Australia

Order

We are a leading provider of value SQL tools for Microsoft SQL Server developers

Single Developer License - for only one SQL Server databases Developer

Site Developer License - for many SQL Server databases Developers

Home   More Software   More Apex Sql Products

Excel Spreadsheets