Deploy Dacpac on remote machine using Powershell

• Dotnetavalanche

  SSC Enthusiast

  Points: 138

  More actions

  July 4, 2018 at 11:30 am

  #365258

  Hi, I am on machine A with windows credentials say UserA and corresponding windows password. I will run powershell script on this machine. SQL 2016 DB is to be deployed on another machine say B.
   but credentials UserA does not have permission on machine B. Say UserB/ pwd has access on machine B.
  Help me get the PowerShell script to achieve this.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734434

  More actions

  July 5, 2018 at 10:59 am

  #1996436

  You can use Get-Credential to enter new credentials.