Skip to content

Instantly share code, notes, and snippets.

@bruceharrison1984

bruceharrison1984/error-output.sh

Last active May 19, 2020 12:40
Show Gist options
  • Save bruceharrison1984/cb06c48fca3d314012fff77c78f4deb7 to your computer and use it in GitHub Desktop.
Save bruceharrison1984/cb06c48fca3d314012fff77c78f4deb7 to your computer and use it in GitHub Desktop.
Download ZIP
Running Sqlpackage v150 on DevOps
Raw
error-output.sh
2020-05-01T19:06:05.0948538Z ##[error]Publishing to database '****' on server '***.database.windows.net,1433'.
Initializing deployment (Start)
Initializing deployment (Failed)
Time elapsed 00:00:06.91
*** An error occurred during deployment plan generation. Deployment cannot continue. The Element class SqlColumnStoreIndex does not contain the Relationship class OrderedColumns.
Raw
run-sqlpackage.ps1
$connectionString = "Server=*****.database.windows.net,1433;Database=*****;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;"
& "C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\150\sqlpackage.exe" /Action:Publish /SourceFile:"./deployment.dacpac" /TargetConnectionString:"$connectionString" /AccessToken:"<service-principal-access-token>" /Diagnostics:True
Raw
username-password.ps1
$connectionString = "Server=*****.database.windows.net,1433;Database=*****;Persist Security Info=False;User ID=<[email protected]>;Password=<password>;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=True;TrustServerCertificate=False;Authentication='Active Directory Password'"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment