Switch from SQL CI Publish command to PowerShell
Published 10 March 2016
This page shows you how to create a PowerShell script using the DLM Automation cmdlets that's equivalent to the SQL CI Publish command.
The SQL CI Publish command takes the database NuGet package created by the Build command and publishes it to a NuGet feed.
This example uses the Publish command in SQL CI to publish the database package to a NuGet feed that requires an API key:
Command line example
sqlCI.exe Publish /package="C:\packages\WidgetShop.1.0.nupkg" /nugetFeedUrl=http://nugetfeedmachinename:8081/nuget/ /nugetFeedApiKey=ed6d7c98-9847-4599-b5a8-323f215b5c89
Here's the equivalent example using the DLM Automation PowerShell cmdlets:
PowerShell example
$package = "C:\packages\WidgetShop.1.0.nupkg" Publish-DlmDatabasePackage $package -NuGetFeedUrl "http://nugetfeedmachinename:8081/nuget/" -NuGetApiKey "ed6d7c98-9847-4599-b5a8-323f215b5c89"
The example above uses the Publish-DlmDatabasePackage cmdlet.
In the DLM Automation PowerShell module, you can also use the Publish-DlmDatabasePackage cmdlet to send schema and documentation information to the DLM Dashboard.
