Category
Product Version
Topic
Subtopic
ApexSQL DevOps toolkit FAQs about notifications, outputs and summaries (4289299)
This article answers on frequently asked questions regarding ApexSQL DevOps toolkit including notifications, outputs and summaries. ... A: There are several ways that could be used as information system to inform you when a pipeline is completed:
How to download and install ApexSQL DevOps toolkit PowerShell cmdlets (4216044)
This article explains how to download the ApexSQL DevOps cmdlets from GitHub and install them, to integrate into Windows PowerShell. ... The ApexSQL DevOps toolkit provides a set of PowerShell cmdlets that can be configured to create a one-click PowerShell script to run your custom SQL Server database CI, CD or custom pipeline.
How to integrate ApexSQL DevOps toolkit PowerShell scripts with Bamboo server (4211712)
Summary This article explains how to configure an Atlassian Bamboo build server for setting up a continuous integration and delivery process with the ApexSQL DevOps toolkit. ... Description Atlassian Bamboo is a continuous integration (CI) and continuous deployment (CD) build server, which can be used for automating release management for a software application, by creating continuous delivery pipelines.
ApexSQL DevOps toolkit PowerShell scripts initial setup and configuration (4291408)
ApexSQL DevOps toolkit offers a powerful, free and open-source collection of PowerShell scripts that will allow you to create and fully automate CI and CD workflow pipelines. ... Description ... In this worked example, we are going to assume just a few basic steps.
How to setup continuous integration and continuous delivery tasks using the ApexSQL DevOps toolkit - Azure DevOps Server (TFS) / Azure DevOps Services plugin (4214628)
The ApexSQL DevOps toolkit is a database continuous integration and continuous delivery workflow designer. ... It consists of customizable steps which allow creating pipelines for building a database from source control repository, test and review database project changes and deploy them to update a target/production database.
Walkthrough example of configuring a SQL Server database continuous integration pipeline with the ApexSQL DevOps toolkit (4214646)
In this article, we’ll walk through the process, end to end, on how to set up a CI pipeline. ... We’ll be using the ApexSQL DevOps toolkit web dashboard but the same principles apply to configuring the toolkit to run with PowerShell scripts and build-server plug-ins.
Minimal SQL Server permissions for ApexSQL Developer tools (4216304)
Description ... In order to properly use ApexSQL Developer tools certain minimal SQL Server permissions need to be allowed on databases that are being used. ... Required permissions ... Required permissions are public SQL Server role and the public role membership that need to be configured along with the login.
Quick overview of ApexSQL DevOps toolkit – VSTS/Azure DevOps plugin (4209489)
As an new addition to the plug-in family of the ApexSQL DevOps toolkit, a database continuous integration and continuous delivery solution, we are announcing Azure DevOps plugin. ... This plugin will integrate easy-to-use database CI and CD automation workflow designer to Azure DevOps project environment and expand it with database build, testing and deployment capabilities.
SQL Server database continuous integration workflow DOCUMENT step - Creating database documentation (4216015)
In this article, the Document step of the Continuous Integration workflow will be described. ... After the Sync step is successfully completed, in this step, database documentation is created, using the latest changed database version.
SQL Server database continuous integration workflow TEST step – Running SQL unit tests against the changes (4211045)
In this part of the continuous integration aka “CI” workflow, the Unit test step will be described. ... After the Populate step is successfully finished, where the new database test data is generated, the Test step is initiated, that will use SQL Server unit tests.
What is SQL Server database continuous integration (CI)? - a high level conceptual overview and walk thru of the steps in a SQL database CI pipeline (4214734)
If you’ve never automated builds in SQL Server before and but are still CI-curious, then this quick high-level overview, should introduce to you the basics and maybe even lead to you wading into the water a little deeper
How to automatically process SQL Server databases with Unit tests (4213183)
In order to begin this process, first the tSQLt, (SQL Server database unit testing framework) has to be installed on the database which will be used for unit testing. ... This can be done manually in SSMS by right-clicking the selected database in the Object explorer, find the Unit tests menu and select Install tSQLt.
Automating database synchronization using a continuous integration solution (4294842)
This article will describe a quick, no-coding approach to automating SQL Server database synchronization via a continuous integration. ... Most of the ways to automate database synchronization usually come down to writing a PowerShell or batch script solution then configuring SQL Server Agent job or the Task scheduler.
Patch Release Notes for ApexSQL DevOps Toolkit 2020.xx (4300573)
Patch Release Notes for ApexSQL DevOps Toolkit 2020.xx <div style="background-color: #f2f2f2;border-top: 1px solid #d3d3d3;height: 50px;padding-left: 30px;padding-top: 5px;padding-bottom: 5px;">Release: 2020.04.0236<p>Date: September 18, 2020</p></div><p> <strong>Fixes:</strong></p><ul><li>Bug 188868: "The method or operation is not implemented" error is encountered when adding the Deploy step into the pipeline</li><li>Bug 189410: "Object reference not set to an instance of an object" error is encountered when adding the Provision step in the pipeline</li></ul><div class="col-md-12 col-xs-12 release_notes_box" style="box-sizing: border-box;min-height: 1px;padding-right: 15px;padding-left: 15px;float: left;width: 1140px;background-color: #f4f4f4;margin: 15px 0px 30px;padding-top: 6px;color: #333333;"><div class="col-md-3 col-xs-4" style="box-sizing: border-box;min-height: 1px;padding-right: 15px;padding-left: 15px;float: left;width: 277.5px;"><p style="box-sizing: border-box;margin: 0px 0px 5px;font-size: 1.4em;">Release:</p></div><div class="col-md-9 col-xs-8" style="box-sizing: border-box;min-height: 1px;padding-right: 15px;padding-left: 15px;float: left;width: 832.5px;"><p style="box-sizing: border-box;margin: 0px 0px 5px;font-size: 1.4em;">2020.04.0239</p></div><div class="col-md-3 col-xs-4" style="box-sizing: border-box;min-height: 1px;padding-right: 15px;padding-left: 15px;float: left;width: 277.5px;"><p style="box-sizing: border-box;margin: 0px 0px 5px;font-size: 1.4em;">Date:</p></div><div class="col-md-9 col-xs-8" style="box-sizing: border-box;min-height: 1px;padding-right: 15px;padding-left: 15px;float: left;width: 832.5px;"><p style="box-sizing: border-box;margin: 0px 0px 5px;font-size: 1.4em;">December 25, 2020</p></div></div><p style="box-sizing: border-box;margin: 0px 0px 10px;font-size: 1.4em;color: #333333;"><span style="box-sizing: border-box;font-weight: 700;">Fixes:</span></p><ul style="box-sizing: border-box;margin-top: 0px;margin-bottom: 10px;color: #333333;"><li style="box-sizing: border-box;font-size: 1.4em;">192347: Source is shown as a null value for the Deploy step when the source is used from the package</li><li style="box-sizing: border-box;font-size: 1.4em;">199306: Previously added packages are removed from the Package field when the Deploy step is reopened</li></ul><p> </p><p>Download the latest patch <a href="https://support.quest.com/download-install-detail/6111465" title="Download ApexSQL DevOps toolkit Web dashboard patch 2020.04.0236" target="_blank">here</a></p>
Automated database lifecycle using ApexSQL continuous integration tools – Development (4288672)
This video will cover database baselining, provisioning, committing code to source control, setting continuous integration, and continuous delivery pipelines through ApexSQL DevOps toolkit solutions with advanced workflow customizations.
Automated database lifecycle using ApexSQL continuous integration tools – Source control (4299938)
This video will cover database baselining, provisioning, committing code to source control, setting continuous integration, and continuous delivery pipelines through ApexSQL DevOps toolkit solutions with advanced workflow customizations.
Send logs feature in ApexSQL tools (4288785)
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. ... Every ApexSQL tool collects all important information regarding work processes and stores them in the log files.
Migrating ApexSQL DevOps toolkit – Web dashboard database continuous integration (CI) and continuous delivery (CD) pipeline configurations (4218627)
This article will explain the procedure of moving or copying an existing ApexSQL DevOps toolkit – Web dashboard continuous integration and continuous delivery pipeline configurations to another instance on a different PC machine.
How to perform non-database automated tasks in a database continuous integration pipeline with ApexSQL DevOps Toolkit (4254530)
In the DevOps world, it is a common practice to set up database continuous integration solutions for project deliveries, with as many steps included in a single workflow as possible. ... For the SQL Server project types, most of the database continuous integration and continuous delivery use cases are covered with ApexSQL DevOps toolkit solutions, including both standalone and continuous integration servers plugins.
Configuring Azure DevOps build-release pipelines with ApexSQL DevOps toolkit plugin (4247737)
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.
Pipeline cannot be deleted in the Pipelines tab when using Table view (4244200)
Note: Screenshot attached ... Software bug. ... This is being tracked as 181202.
Getting error "Cannot find module 'azure-pipelines-task-lib" when comparing and synchronizing databases hosted on Azure (4258188)
Error: "Cannot find module 'azure-pipelines-task-lib'” is encountered when trying to compare and synchronize schema for two databases. ... This happens when the source database is hosted on Azure VM while the second database is Azure SQL Database.
Is my ApexSQL application version vulnerable to Log4j - CVE-2021-44228? (4309395)
Determine if the installed ApexSQL application version is vulnerable to <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">Log4j - CVE-2021-44228</a>. The discovery of critical vulnerability <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">CVE-2021-44228</a> in the Apache Log4j library (CVSS severity level 10 out of 10). <p><strong>Unaffected products:</strong></p><p>ApexSQL Analyze<br>ApexSQL Audit<br>ApexSQL Backup<br>ApexSQL Build<br>ApexSQL Compare<br>ApexSQL Complete<br>ApexSQL Data Diff<br>ApexSQL Data Diff for MySQL<br>ApexSQL Database Power Tools for VS Code<br>ApexSQL Decrypt<br>ApexSQL Defrag<br>ApexSQL DevOps Toolkit<br>ApexSQL Diff<br>ApexSQL Diff for MySQL<br>ApexSQL Discover<br>ApexSQL Doc<br>ApexSQL Doc for MySQL<br>ApexSQL Enforce<br>ApexSQL Generate<br>ApexSQL Job<br>ApexSQL Log<br>ApexSQL Manage<br>ApexSQL Mask<br>ApexSQL Model<br>ApexSQL Monitor<br>ApexSQL Plan<br>ApexSQL Propagate<br>ApexSQL Pump<br>ApexSQL Recover<br>ApexSQL Refactor<br>ApexSQL Script<br>ApexSQL Search<br>ApexSQL Source Control<br>ApexSQL Trigger<br>ApexSQL Unit Test</p><p></p>
Database Tools License Portal - How to download and activate term or perpetual offline licenses? (4370567)
Database Tools License Portal - How to download and activate term or perpetual offline licenses? <p>For term and perpetual offline licenses, users can follow the below steps to download and activate the license from the online license management portal.<br><br>1.
ApexSQL DevOps toolkit – Prerequisites configuration (4312272)
Self-hosted Windows agent running under domain account meeting minimum requirements for installing ApexSQL DevOps toolkit ... This article will cover prerequisites configuration for the following steps:
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All