How do you update Powershell SQLChangeAutomation Module?

• 
  Try a -Force here. I think that will help, but not in a place to test, and everyone in the UK is gone for the weekend. Can you check the version of SCA on your build server?

  way0utwest August 29, 2018 23:29

  - 0 +
• 
  The TFS extension is set to use the latest version in its build.

  l570 August 30, 2018 11:34

  - 0 +
• 
  Update-Module with the -Force flag gave me the same issue.  Trying a -Force on the Install-Module gave me:
  

  
  WARNING: The specified module 'SqlChangeAutomation' with PowerShellGetFormatVersion '2.0' is

   not supported by the current version of PowerShellGet. Get the latest version of the PowerS

  hellGet module to install this module, 'SqlChangeAutomation'.

  
  And of course I checked PowerShellGet and I have the latest (1.6.7)

  l570 August 30, 2018 11:41

  - 0 +
• 
  hmm, I've asked a few people for help here. I'm not sure what's broken.

  way0utwest August 30, 2018 14:58

  - 0 +
• 
  Unfortunately PowerShell has a tendency of loading the old version of PowerShellGet by default, even if you've got a newer version installed. To be absolutely certain, you'll need to run the following:
  

  Import-Module PowerShellGet -MinimumVersion 1.6 -Force<br>Import-PackageProvider PowerShellGet -MinimumVersion 1.6 -Force<br><br>Install-Module SQLChangeAutomation

  I'm assuming you're doing this all on a development machine to test things out by the way. The various SQL Change Automation build/release extensions have their own auto-updating mechanism to download the latest version of SQL Change Automation from PowerShellGet, which does some more complicated things to make sure that it can work without admin permissions (if you're interested in the gory details, you can look in the extension directory for the file PowerShellGallery.ps1 to see what we do).
  
  

  Mike U August 31, 2018 12:49

  - 0 +
• 
  Yes, I am working in the Dev environment.
  
  I had to add the -Force and -AcceptLicense flags before I got it to work, but now I have the latest version (3.0.3.2525) installed side by side with the 3.0.2.2482 version.  
  

  l570 August 31, 2018 13:01

  - 0 +
• 
  A couple things I heard back. First, did you have a new Posh session between the provider install and the get install?
  
  This page (https://documentation.red-gate.com/sca3/getting-started/installation/installing-powershell-components) asks for that. Also, is the new session elevated?

  way0utwest September 05, 2018 16:17

  - 0 +
• 
  Not the first attempt, no, but on subsequent attempts, I did have separate powershell sessions with elevated permissions.

  l570 September 05, 2018 19:29

  - 0 +

Add comment

Please sign in to leave a comment.