OmniAudit Description

Sponsored Links


OmniAudit automatically and transparently tracks changes to data in any column of any table in your Microsoft SQL Server 7.0 or 2000 databases. Simply select the tables and columns you want to audit, and OmniAudit does everything for you. OmniAudit captures changes regardless of the application used to change the data: a commercial software package, an in-house application, or even the native tools provided with SQL Server such as Query Analyzer…OmniAudit catches it all and records what data was changed and who changed it.

OmniAudit not only captures before and after values for each changed column, but also identifies: the user, date and time, the workstation used, and the application used to make the change.

You decide which tables and columns to audit; OmniAudit automatically generates triggers to maintain an audit trail of all inserts, updates, and deletes made to that data. OmniAudit is a completely server-side solution which requires no modifications to any client software.

Data auditing can be valuable to an IT organization in a number of ways:

* Database administrators can more easily troubleshoot and track down the origin of data corruption.

* Organizations with internal or regulatory requirements for following the history of data can do so easily, even if their software doesn\'t already handle this requirement.

* Software developers can more easily develop and debug applications by tracing how data gets changed by any particular function of the software. Find unintentional side-effects faster and easier.

* Quality Assurance functions can validate data altering features more quickly and with greater accuracy.

Using OmniAudit Log Viewer, you can quickly and easily sift through the compiled audit log history in a number of ways. Filter audit log data on date/time, table/column, user, workstation…any of the key variables tracked by OmniAudit. Audit log data can be exported to standard file formats including text, Excel and XML.



Publisher: | Download

Category: Programming > Database Development

Size: 6.88MB

OS: Win 95/98/Me/NT/2000/XP

Downloads: 19811

License: Shareware

More Software Like OmniAudit

TxtToSql

TxtToSql is a tool to import text (csv) file data to SQL Server. Main features: 1 Import text (csv) file data into Sql Server Table. 2 Run SQL command, see importing results. 3 Support export text(ntext) and image field. 4 Support Unicode.
Downloads: 20700 - Shareware - Download Now

DTM OLE DB Provider List

DTM OLE DB Provider List is a free command line tool that enumerates or export to text file the list of installed OLE DB Providers. Generated text file is ready to open by Excel. It is handy tool for DBA and advanced users who works with OLE DB/DAO.
Downloads: 20595 - Freeware - Download Now

DTM Data Generator for Excel

DTM Data Generator for Excel is a tool that generates test Excel spreadsheets. The tool provides dozens built-in data generators: address, phone, e-mail, name, etc. The value library makes data more realistic. Custom generators are also available.
Downloads: 21742 - Demo - Download Now

blueshell Data Guy

The blueshell Data Guy is an ADO-based editor for virtually all types of databases. This program supports Jet (Access and ISAMs like dBase, Paradox etc.), Oracle and SQL server, other OLEDB and ODBC providers, Cut and Paste, Drag and Drop, Explorer..
Downloads: 20097 - Shareware - Download Now

blueshell Active Tables for .NET

Use VB 5/6 as well as all the languages of .NET (like C#, VB.NET and J#) to connect to various databases including Oracle, MS SQL Server, MySQL, Jet and more using ADO. Develop reliable and easy-to-use database applications in no time at all!
Downloads: 20069 - Shareware - Download Now

Sponsored Links