Apex SQL Log 2011.03.1092

A powerful SQL database auditing utility especially intended for DBAs who need to find out exactly when and how an accident occurred in a specific database, as well as view details on who was involved
Apex SQL Log is a reliable and useful software solution that comes in handy for database administrators who need to audit data, schema and tables, as well as rollback database changes and recover missing or damaged data.

Working with multiple databases and granting read / write permissions to various users might affect your SQL data and some of the connected tables will not work properly anymore. For instance, if a user modifies the primary key of a table, the other child tables that are connected through a primary key will not work anymore.

Using Apex SQL Log you are able to determine who changed data and when the change occurred. This way, you can read the transaction log for the current database and view all the information you need to establish which user created, changed or dropped a database object.

Since it works smoothly with SQL Server, the application requires you to specify the server that needs to connect to, then choose the authentication mode and the database you want to inspect. After that, Apex SQL Log will automatically generate a log file that contains all the details related to database actions.

Additionally, you can filter your searches by time range, by operations such as alter, create or drop, or simply by tables.

The application provides you with three options in order to store the generated information. You can either open the results in a grid format, export them to a specified file format or simply create batch files.

The right click menu allows you to export the checked entries to CSV, HTML, XML or SQL format, create undo or redo scripts and copy specific rows to clipboard.

In closing, you can use Apex SQL Log when you need to read SQL Server database transaction logs to find out exactly who performed the actions in a specified period of time and recover lost or damaged data effortlessly.

Reviewed by , last updated on December 19th, 2013


file size:
23.5 MB
price:
$1499.00
 
developed by:
Apex SQL Tools
license type:
Trial 
operating system(s):
Windows XP / Vista / Vista 64 bit / 7 / 7 64 bit
category:
C: \ Internet \ Servers \ Database Utils

In a hurry? Add it to your Download Basket!

softpedia rating

4.5/5

user rating 18

3.4/5
 

0/5

Rate it!
18 Screenshots
Apex SQL Log - Apex SQL Log will provide users with a powerful SQL database auditing tool that analyzes SQL ServerApex SQL Log - Users will be able to access options such as Export to CSV / HTML / SQL Script / XML or SQL BULKApex SQL Log - The View tab will offer a list of options like Group by box, Show filter row, Sorting or Auto size columnsApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL LogApex SQL Log
What's New in This Release:
  • Fixed:
  • The "Connection to the < databasename > on the server < hostname > failed." error is encountered when attempting to connect to any SQL Server instance if the application is running on Windows XP or on Windows Server 2003
read full changelog
 

Application description

ApexSQL Log is a powerful SQL database auditing tool that analyzes SQL Server's own Transaction Log to display informa...

Add your review!

SUBMIT