ApexSQL Data Diff knowledgebase – Table of contents

Permissions and requirements

• Minimal SQL Server permissions for ApexSQL Developer tools
• Minimum requirements for installing ApexSQL Data Diff
• Supported software for ApexSQL Data Diff

Configuration and setup

• How to remove ApexSQL tools from SQL Server Management Studio

Data synchronization

• How to synchronize data between databases with different settings

Features

• Using the Row filter option in ApexSQL Data Diff
• Benefits of using the Row filter in SQL database comparison
• How to perform custom object mapping in ApexSQL Data Diff
• How to create custom schema mappings
• Custom database comparison keys
• Save project as batch file
• How to execute large SQL scripts
• Using regular expressions in ApexSQL tools
• Pre-synchronization warnings and messages in ApexSQL Data Diff
  

Database packages

• All about ApexSQL database installer packages

Reports and exports

• How to export specific tables/rows as HTML and HTML plain reports
• Inventory of ApexSQL Data Diff and ApexSQL Diff output files

Source control

• Setting up the Source control wizard for a Git repository

Command line interface

• ApexSQL Data Diff Command Line Interface (CLI) switches
• How to filter compared objects using the Inc/Exc switch with the ApexSQL Data Diff CLI
• How to execute large SQL scripts
• Utilizing the “no differences detected” return code in ApexSQL change management console applications
• How to setup an e-mail alert system for ApexSQL tools
• Four ways of handling database/login credentials during automated execution via the CLI
• How to use an argument file in the CLI
• How to use a project file in the CLI