Skip to content

Instantly share code, notes, and snippets.

@Alex-Yates

Alex-Yates/DeployFromSourceWithFilter.ps1

Created November 14, 2016 18:23
Show Gist options
  • Save Alex-Yates/d5dd22f213d2c61827458020e794949a to your computer and use it in GitHub Desktop.
Save Alex-Yates/d5dd22f213d2c61827458020e794949a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DeployFromSourceWithFilter.ps1
# This script uses cmdlets from Redgate DLM Automation, which is part of the SQL Toolbelt
# Documentation for these cmdlets is available at:
# https://documentation.red-gate.com/display/DLMA2/Cmdlet+reference
$sourceCode = "Documents/Ponies_dev/state"
$twilightSparkleDb = New-DlmDatabaseConnection -ServerInstance "myServer\myInstance" -Database "TwilightSparkle" | Test-DlmDatabaseConnection
$filterPath = "Documents\Ponies_dev\filters\TwilightSparkle.scpf"
Sync-DlmDatabaseSchema -Source $sourceCode -Target $twilightSparkleDb -filterPath $filterPath
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment