ObjectDisposedExceptionerrors when publishing packages to NuGet repositories
DriftStatus. Possible values:
Unknown. This property can be used to control whether or not to go ahead with a release when one or more objects in the target environment differ to the project baseline, which can happen when modifications have been made to a live environment. See the documentation for more information.
New-DatabaseReleaseArtifactwould set the
DeployPathvariable in the script to a nonexistent directory.
DriftRevertScript.sql. This script contains code to revert drift, as well as a commented section of code that can be copied and pasted into a new migration (allowing the drift to be incorporated back into project).
* Users of SCA projects will know this as the "resync" script that is produced during a patch build, as part of the drift analysis process.
Use-DatabaseReleaseArtifactcmdlets with SQL Change Automation projects more detailed logging will be provided to the default output stream
Use-DatabaseReleaseArtifactwill now output a warning if the
xp_logeventcall used to log deployments to SQL Monitor fails, rather than silently ignoring the failure.
-DisableMonitorAnnotationargument to stop
New-DatabaseReleaseArtifactcmdlet no longer raises an exception with SQL Change Automation projects when tables have drifted in the target environment
SqlCmdVariablesparameter to the
New-DatabaseReleaseArtifactcmdlet, supporting SQLCMD variables with release-specific values.
DatabaseReleaseArtifact, so this feature can be used with manual release processes too.
New-DatabaseProjectObjectcmdlet that provides the same functionality as the deprecated
New-DlmManualDatabaseSchemaValidation. The old cmdlet name will still work.
Use-DatabaseReleaseArtifact, add support for the
DisableMonitorAnnotationflag for SQL Change Automation projects.
Initial release of SQL Change Automation, which replaces DLM Automation, and also
includes the functionality previously provided by ReadyRoll.
The SQL Change Automation PowerShell module provides cmdlets that allow you to automate building, testing, and deploying SQL Server databases. See the documentation for more information.
* SQL Change Automation projects were formerly known as ReadyRoll projects, and provide a migrations-based approach to database development.
SQL Change Automation is now available from the PowerShell Gallery to make it easier to configure automation environments.
All existing DLM Automation features and workflows continue to be supported. Existing scripts that use DLM Automation cmdlets will continue to work with the SQL Change Automation module.
The Octopus Deploy step templates for DLM Automation import the DLM Automation PowerShell module by name, which means they will not work if the tentacles are updated to SQL Change Automation. We will be releasing new versions of the step templates which support the SQL Change Automation module, but until then, don't upgrade any Octopus tentacles to SQL Change Automation.