ApexSQL Generate knowledgebase – Table of contents

Permissions and requirements

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

Configuration and setup

• How to remove ApexSQL tools from SQL Server Management Studio

Connection

• How to use Aliases in ApexSQL Generate

Features

• ApexSQL Generate – Applying settings to children
• Save project as batch file
• Seed feature in ApexSQL Generate
• Table mapping in ApexSQL Generate

Generators

• All about user defined generators
• The Regular expression generator
• How to generate randomized test data in ApexSQL Generate
• How to generate sequential data in ApexSQL Generate

Command Line Interface

• ApexSQL Generate Command Line Interface (CLI) switches
• How to setup an e-mail alert system for ApexSQL tools
• Four ways of handling database/login credentials during automated execution via the CLI