OmniAudit Free Download at datapicks.com - OmniAudit allows you to track changes to data in any table for MSSQL 7/2000.

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.

Related keywords: audit, database, sql server, mssql, audit trail

Top Database & SQL / Software Development programs

1) CASE Studio 2 v 2.23
Powerful database design tool which allows you to visually create Entity Relationship Diagrams (ERD) for various database systems - MS SQL, Oracle, DB2, MySQL, InterBase, Sybase etc. Features: ERD, SQL script generation, Reverse engineering...

2) Visual Open DB 1.75
Visual Open DB is a generic data analysing application that allows you to query any valid data source. It can be used by end users to perform data analysis and developers to interrogate database tables and views.

3) Aqua Data Studio 4.0
Aqua Data Studio is a SQL editor and developer tool that allows developers to easily create edit and execute SQL scripts as well as browse database structures

4) DBF Viewer 2000 2.45
DBF Viewer 2000 is a powerful, compact and easy-to-use viewer and editor for DBF files. You can view, edit, sort, use query by example, delete duplicates, create, print database tables a export the data from them to a variety of formats.

5) DB Explorer 3.0.0
Compare two database schemas and/or table data rows and report differences. Synchronise the differences for one or other database. Sync Schema generates the SQL DDL statements. Sync Data either transfers the rows or generates SQL DML statements.

6) DBF to CSV 2.01
The DBF to CSV program allows you to convert your dbf files to csv (comma-separated value) format. Generally, you can use any delimiter, such as TAB, semicolon etc. The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats

7) TOAD for Oracle Freeware 8.5
TOAD® empowers developers and DBAs to be more productive by providing an intuitive graphical user interface to Oracle. TOAD is a powerful, low-overhead tool that makes PL/SQL development faster and easier and simplifies database administration.

8) SQLite3 database manager LITE 3.1
SQLite3 database manager. Development tool for managing all database objects. SQL builder.

9) GIS ObjectLand 2.6.5
GIS ObjectLand is a universal Geographic Information System for Windows. Key features: vector-raster maps; multiuser data editing; import/export for MIF/MID, SHP, DXF, DBF, CSV; access permissions for users; using other DBMS (ODBC); COM interfaces.

10) Exportizer Pro 3.7
Exports database tables (DB, DBF, MDB, XLS, GDB, IB, HTML, UDL, TXT, CSV) to clipboard or file (XLS, RTF, XML, HTML, TXT, CSV, DBF). Many options allow full control over output.

New Database & SQL / Software Development programs

1) MyDeveloper Studio 3.00 beta
Powerful database development and administration environment for MySQL. Presents a large set of database tools for simplifying interaction with MySQL and automating the database development process. Has a unique built-in stored routine debugger.

2) SQL Data Examiner 2.2.0.20
SQL Data Examiner 2008 is a multi-platform data comparison and synchronization tool that merges selected databases with just a few clicks. The tool simplifies the process of data migration and saves hours of boring manual work.

3) Mexico Postal Code Database (Gold Edition) July.2008
Mexico postal codes database subscription. The database includes postal code, city name, colony name, state code, state name, latitude and longitude, time zone and area code in Mexico.

4) MS Access Print Multiple Objects Software 7.0
Print many MS Access tables, queries, forms, pages, modules, macros and reports without having to open each one. MS Access 2000 or higher required.

5) Oracle Copy Tables to Another Oracle Database Software 7.0
Copy tables from one Oracle database to another. Provide the login information for both databases.

6) FoxPro Copy Tables to Another FoxPro Database Software 7.0
Copy tables from one FoxPro database to another. Provide the file locations for both databases to connect. Connect to FoxPro via DBC file or multiple DBF files in a folder.

7) Export Query to Text for SQL Server 1.04.22
Export Query for Microsoft SQL Server helps to save a query results to text file. The program supports delimited or fixed length formats. Export utility has easy to learn and to use wizard interface. All modern versions of SQL Server are supported.

8) MySQL Copy Tables to Another MySQL Database Software 7.0
Copy tables from one MySQL server to another. Provide the login information for both databases.

9) MS Access Copy Tables to Another Access Database Software 7.0
Copy tables from one Access database to another.

10) SQL Script Builder 1.6.3.53
SQL Script Builder is powerful software that create a database file or sql script from any ODBC data source. The script or file will migrate the table(s) and the records. Scripts comes in 5 formats ; MySql, MS SQL, Oracle, Pervasive and PostgreSQL.