ObjectDisposedException
errors when publishing packages to NuGet repositoriesNew-DatabaseReleaseArtifact
: DriftStatus
. Possible values: NotDrifted
, Drifted
and 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-DatabaseReleaseArtifact
would set the DeployPath
variable 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.
New-DatabaseReleaseArtifact
or Use-DatabaseReleaseArtifact
cmdlets with SQL Change Automation projects more detailed logging will be provided to the default output streamUse-DatabaseReleaseArtifact
will now output a warning if the xp_logevent
call used to log deployments to SQL Monitor fails, rather than silently ignoring the failure.-DisableMonitorAnnotation
argument to stop xp_logevent
being called.New-DatabaseReleaseArtifact
cmdlet no longer raises an exception with SQL Change Automation projects when tables have drifted in the target environmentSqlCmdVariables
parameter to the New-DatabaseReleaseArtifact
cmdlet, supporting SQLCMD variables with release-specific values.SyncDatabaseSchema
cmdlet.ReleaseUrl
, on DatabaseReleaseArtifact
, so this feature can be used with manual release processes too.New-DatabaseProjectObject
cmdlet that provides the same functionality as the deprecated New-DlmManualDatabaseSchemaValidation
. The old cmdlet name will still work.Use-DatabaseReleaseArtifact
, add support for the DisableMonitorAnnotation
flag 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.