All ApexSQL console applications with Command line interfaces (CLI)
This article describes how to create e-mail alert system for ApexSQL tools using PowerShell in order to send e-mails upon executed ApexSQL tool providing the necessary information.
Performing continuous auditing with ApexSQL Log enables users to seamlessly audit SQL Server databases for all DML and DDL changes that occur on the audited database, directly from the transaction log. The audited data is then stored in the repository tables which can be created in any SQL Server database on any connectible SQL Server instance, and these tables will then be continuously updated with new auditing data.
When continuous auditing is performed, audited data is stored in one of two sets of repository tables, depending if user is performing general auditing or before-after auditing. In this article we are going to provide information on the structures of these tables.
ApexSQL Log, ApexSQL Recover
This article helps users to gather information to send to the ApexSQL Support team to receive adequate and timely help with a SQL recovery process
ApexSQL Log, ApexSQL Recover
This article provides key information and links to all important recovery-related articles. They are categorized by
ApexSQL Backup, ApexSQL Clean, ApexSQL Data Diff, ApexSQL Diff, ApexSQL Doc, ApexSQL Generate, ApexSQL Log, ApexSQL Restore, ApexSQL Script, ApexSQL Trigger, ApexSQL Unit Test
This article explains how to automate the execution of ApexSQL tools via the CLI while handling the passing of database credentials or using Windows authentication.
Even though it seems as the most practical and simple solution, restoring the database after the disaster can be a two-fold step-back. One, it will most likely recover the data and restore the database to the state/time when the backup was created, but all database changes after the backup will be completely lost. And two, restoring the database will prevent recovery processes with third party tools, since the original MDF and LDF files and the information within will be lost once the restore process finishes. In this article, we’ll discuss adequate steps required to be prepared for a successful recovery using 3rd party SQL Server database recovery tools
Several ApexSQL products including ApexSQL Clean, ApexSQL Data Diff, ApexSQL Diff, ApexSQL Generate, ApexSQL Log and ApexSQL Script
Note that this feature may added to other tools not listed above
This article explains all about the Save project as batch file feature
ApexSQL Log is a SQL Server database transaction log reader which allows users insight into SQL Server database transaction log files and backup. ApexSQL Log can be used both locally or remotely in order to perform auditing and recovery jobs. Users can audit database changes and present in a comprehensive grid, where they can be analyzed and inspected in great detail, including who made the change and when, as well as the before-after change values and full history of affected rows regardless of the auditing method (local or remote).
ApexSQL Log is a tool which allows you to view transaction log and audit, revert, or replay data and object changes that have affected a SQL database including those that had occurred before it was installed. It restores damaged or missing data and objects and also captures information on the user, application, and host that made those changes.