Permissions and requirements
- Minimum requirements for installing ApexSQL Script
- Supported software for ApexSQL Script
- Minimum permissions required to install and use ApexSQL products
Configuration and setup
- Silent installation and un-installation of the ApexSQL products
- How to configure remote access and connect to a remote SQL Server instance with ApexSQL tools
- How to turn off the ApexSQL auto-updater
- How can I tell if I have the latest version of my ApexSQL software
- How to use encrypted connections to SQL Server within ApexSQL tools
Licensing and activation
Features
- How to create custom schema mappings
- How to narrow the data sub-set for object scripting
- Save project as batch file
- Using regular expressions in ApexSQL tools
Packages
- All about ApexSQL database installer packages
- How to use ApexSQL Script to deploy a database as a .Net executable
Source control
Command Line Interface
- ApexSQL Script Command Line Interface (CLI) switches
- General usage and the common Command Line Interface (CLI) switches for ApexSQL tools
- How to use an argument file in the CLI
- How to use a project file in the CLI
- How to use bitwise set in ApexSQL CLI
Scheduling and automation
- Four ways of handling database/login credentials during automated execution via the CLI
- How to automate and schedule CLI execution with SQL Server Job
- How to automate and schedule CLI execution with Task Scheduler
- How to create a login form dialog using PowerShell, accept user input and pass it to an ApexSQL console application
- How to email the output of a scheduled CLI job
- How to setup an e-mail alert system for ApexSQL tools
