Best way to install DLM automation

• 
  I tried upgrading the DLM tools:

  Update-Module SqlChangeAutomation<br>
  <br>
  Untrusted repository<br>
  You are installing the modules from an untrusted repository. If you trust this repository, change its InstallationPolicy value by running the Set-PSRepository cmdlet. Are you sure you want to install the<br>
  modules from 'PSGallery'?<br>
  [Y] Yes  [A] Yes to All  [N] No  [L] No to All  [S] Suspend  [?] Help (default is "N"): A<br>
  <br>
  License Acceptance<br>
  Any use of this software is subject to the terms of the Redgate Standard EULA:<br>
  see https://www.red-gate.com/sca/EULA/PowershellModule<br>
  <br>
  INFORMATION - Use of SQL Change Automation requires<br>
  licensing in line with the Redgate End User License Agreement.<br>
  See&nbsp;Red-gate.com/EULA&nbsp;for more information.<br>
  Do you accept the license terms for module 'SqlChangeAutomation'.<br>
  [Y] Yes  [A] Yes to All  [N] No  [L] No to All  [S] Suspend  [?] Help (default is "N"): y

  
  

  But that had no effect.

  SQL Compare Command Line V13.6.6.8310<br>
  =============================================================================================================================================================================================================<br>
  Copyright c 1999 - 2018 Redgate Software Ltd<br>
  <br>
  DLM Automation: in trial, expires 2023/02/20 15:30:08 +01:00<br>
  Automation License: in trial, expires 2023/02/20 15:30:08 +01:00<br>
  Registering data sources<br>
  <br>
   -#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-<br>
  Console Error Output (StdErr) :<br>
  Error: Comparison of '.' and 'MACHINE\SVR' failed: The database snapshot was saved by a newer version of SQL Compare<br>
  Comparison of '.' and 'MACHINE\SVR' failed: The database snapshot was saved by a newer version of SQL Compare<br>
  RedGate.Legacy.CommandLine.FatalExecutionException<br>
     at RedGate.SQLToolsCommandLine.CommandProcessor.FatalExceptionHelper(String message, Exception ex)<br>
     at RedGate.SQLToolsCommandLine.CommandProcessor.RunComparison()<br>
     at RedGate.SQLToolsCommandLine.CommandProcessor.Run()<br>
  Caused by:<br>
    The database snapshot was saved by a newer version of SQL Compare<br>
    RedGate.SQLCompare.Engine.Registration.ReadFromSnapshot.UnsupportedSnapshotException<br>
       at RedGate.SQLCompare.Engine.Database.LoadFromReader(NullableBinaryReader reader, Database originalForMappings, Nullable`1 options)<br>
       at RedGate.SQLCompare.Engine.Database.LoadFromStream(Stream f, Database originalForMappings, Nullable`1 options)<br>
       at RedGate.SQLCompare.Engine.Database.LoadFromDisk(String fileName, Database original, Nullable`1 options)<br>
       at RedGate.SQLCompare.Common.CompareEngineExecutor.DoRegisterDatabaseForCompare(Database database, SnapshotSource dataSource)<br>
       at RedGate.SQLCompare.CommandLine.CommandLineCompareEngineExecutor.DoRegisterDatabaseForCompare(Database database, SnapshotSource dataSource)<br>
       at RedGate.Legacy.ProgressTasks.ProgressTask.ExecuteSubTasks()<br>
       at RedGate.Legacy.ProgressTasks.SimpleProgressTaskExecutor.DoTasks()

  
  

  How do I install V 14 without a GUI?
  

  LouisSomers January 24, 2023 15:40

  - 0 +
• 
  Yes, the licensing of the SQL Compare command line has indeed changed. Could you try the /allUsers switch as described here.
  
  

  David Atkinson January 24, 2023 19:37

  - 0 +
• 
  Thank you. I finally managed to install Sql Compare 15 by extracting the MSI file form SqlToolbelt and then installing it on the deployment server using an msiexec commandline.
  
  Then I tried to activate it with the /allUsers option which does not give the unsupported error any more.
  Only I run into this problem:
  "All 5 of the entitlements for serial #### have already been claimed. Login to www.red-gate.com to view your licenses."
  

  
  

  I logged in but cannot see any seperate DLM license (we used to have one).
  
  Is it still possible to run the DLM tools on a server with a toolbelt license (it used to be included) or will we now have to get extra licenses for the build and deployment servers?
  

  LouisSomers January 25, 2023 10:39

  - 0 +
• 
  Hi Louis, 
  
  I have just adjusted your license which should get rid of the below message; 
  "All 5 of the entitlements for serial #### have already been claimed. Login to www.red-gate.com to view your licenses."
  
  Please could you try exactly the same steps again and let us know whether it is successful for you? 
  
  You also mentioned that you don't see a DLM license anymore. DLM was replaced by SQL Change Automation which you should see listed in your SQL Toolbelt bundle.

  Robyn January 25, 2023 16:09

  - 0 +
• 
  I tried it now, but I get exactly the same message.

  LouisSomers January 26, 2023 08:00

  - 0 +
• 
  Hi @LouisSomers
  
  Apologies, can you try again please, it should work now.

  Victoria W February 02, 2023 12:31

  - 0 +
• 
  Hi Victoria,
  Sorry, RedGate has handled this privately via email (support ticket #285091).
  It's all registered and working now.
  I should have closed this.
  Thanks again,
  Louis

  LouisSomers February 02, 2023 12:39

  - 0 +

Add comment

Please sign in to leave a comment.