Default option settings in ApexSQL products

The defaults buttons in the Project window

Applies to

All ApexSQL tools

Summary

In this article, it will be explained how to use ApexSQL defaults, My defaults, and Save as my defaults options to save and apply the default option set for ApexSQL tools and add-ins.

Send logs feature in ApexSQL tools

Send logs button in ApexSQL SSMS add-ins

Applies to

All ApexSQL tools

Summary

In this article, it will be explained how to use the Send logs feature for sending application log files through ApexSQL tools to the support team.

Configuring Azure DevOps build-release pipelines with ApexSQL DevOps toolkit plugin

ApexSQL DevOps toolkit tasks

Applies to:

ApexSQL DevOps toolkit – Azure DevOps plugin

Summary

Standard usage of Azure DevOps pipelines implies that projects are built with the build pipelines, where deploy artifacts would be created, and deployed through the release pipelines. This concept is supported with the ApexSQL DevOps toolkit extension for Azure DevOps when it comes to SQL database projects and this article will explain necessary configuration within ApexSQL integrated tasks to setup this workflow.

Handling NuGet packages with ApexSQL DevOps toolkit

NuGet package is a recommended way to move and deploy projects through DevOps infrastructure for database and other types of projects. It is a Microsoft based solution that is especially convenient when said infrastructure contains different environments like development, QA/testing or production environment.

How to set automated database schema validation

In situations where deployment of database script might be delayed due to review process or when multiple project branches are automatically deployed to a single stage environment there is always a possibility that target schema was changed in relation to prepared deployment script. This might be the cause for script execution failure and consequential database issues.