ApexSQL Script knowledgebase – Table of contents

Permissions and requirements

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

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

• Setting up the Source control wizard for a Git repository

Command Line Interface

• ApexSQL Script Command Line Interface (CLI) switches
• How to use bitwise set in ApexSQL CLI
• 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 a project file in the CLI
• How to use an argument file in the CLI