Permissions and requirements
- Minimal SQL Server permissions for ApexSQL Developer tools
- Minimum requirements for installing ApexSQL Diff
- Supported software for ApexSQL Diff
- List of unsupported Azure options for ApexSQL Diff
Configuration and setup
Features
- How to create custom schema mappings
- Save project as automation script
- Using ApexSQL’s Snapshot Utility
- How to execute large SQL scripts
- How to narrow database schema comparison and synchronization to affected objects only
- Database synchronization warnings and messages in ApexSQL Diff and ApexSQL Diff for MySQL
- Using regular expressions in ApexSQL tools
SSIS comparison
Packages
Reports and exports
- Exporting schema comparison results to Excel
- Exporting schema comparison results to an HTML report
- Exporting schema comparison results to a simple HTML report
- XML schema difference export
- ApexSQL Diff – Exporting SQL data sources
- Inventory of ApexSQL Data Diff and ApexSQL Diff output files
Source control
- Setting up the Source control wizard for a Git repository
- Configuring ApexSQL Diff to work with source control data sources
Command line interface
- ApexSQL Diff Command Line Interface (CLI) switches
- How to use bitwise set in ApexSQL CLI
- How to execute large SQL scripts
- How to change SQL object selections for automated processes/jobs
- 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
