Azure Agent Prerequisites Configuration

For ApexSQL DevOps Toolkit

Requirements:

• Self-hosted Windows agent running under domain account meeting minimum requirements for installing ApexSQL DevOps toolkit

ApexSQL tools:

This article will cover prerequisites configuration for the following steps:

• ApexSQL Build – for the Build step to build temporary test database from a source control repository, test the buildability of changes and validate dependencies
• ApexSQL Generate – for the Populate step to populate empty tables with synthetic static data for testing tables
• ApexSQL Doc – for the Document step to create database documentation or document database changes only
• ApexSQL Script – for the Package step to create a database package ready for deployment
• For deployment process it is necessary to have ApexSQL Diff – for the Sync step to create database schema sync script containing changeset that will be deployed to production
• ApexSQL Data Diff – for the Sync data step to create static data sync script containing static data changes that will be deployed to production
• ApexSQL Mask – for the Mask step to mask sensitive data in staging/development/QA environments

Download and install the following tools:

• sqlcmd Utility
• ODBC Driver for SQL
• The Microsoft SQL Server 2017 Feature Pack - SQLSysClrTypes.msi
• ApexSQLDevOpsToolkit-prereq
  • Rename file extension from .nupkg to .zip
  • Extract contents to folder - C:\[AgentFolder]\_work\
• NuGet
  • Place nuget.exe in C:\[AgentFolder]\_work\_tool\

Continue pipeline steps configuration with How to setup continuous integration and continuous delivery tasks using the ApexSQL DevOps toolkit – Azure DevOps Server (TFS) / Azure DevOps Services plugin