.NET Error when trying to run SQL Prompt Command Line

intGod

When running the SQL Prompt command line, I get this error.

Unhandled Exception: System.IO.FileLoadException: Could not load file or assembly 'System.Memory, Version=4.0.1.1, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

   at System.CommandLine.Parsing.StringExtensions.Tokenize(IReadOnlyList`1 args, CommandLineConfiguration configuration, Boolean inferRootCommand)

   at System.CommandLine.Parsing.Parser.Parse(IReadOnlyList`1 arguments, String rawInput)

   at RedGate.SqlPrompt.Formatting.Bulk.CommandLine.Program.Main(String[] args)

The command I ran was:

C:\"Program Files (x86)\Red Gate\SQL Prompt 10\FormatCommandLine\SqlPrompt.Format.CommandLine.exe" --i-agree-to-the-eula --path c:\Users\XXXXXXXXX --style "C:\Users\XXXXXXXXX\AppData\Local\Red Gate\SQL Prompt 10\Styles\Kristof-f2b8d899-4be0-4ebe-9220-4b63ae5d3fd6.json" --create-backups

Jon_Kirkwood

Hi @intGod
 
Thank you for reaching out to us on the Redgate forums. We're here to help you with the error you encountered in the SQL Prompt command line.
 
Could you please let me know the version you are currently running?
There was a bug that we identified and fixed in version 10.14.10.
 
If you are using a version older than this, would you mind updating to the latest version, v10.14.12, at your earliest convenience? After updating, please check if the error persists.
 
You can download the versions from the following links:
 

• Download SQL Prompt 10.14.10.7538
• Download SQL Prompt 10.14.12.7945

Release notes for reference: 
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-14-release-notes

10.14.10.7538 - Released on 14 March 2024
Fixes

• Fixed "Could not load file or assembly System.Memory" exception, occuring when using SqlPrompt.Format.CommandLine.exe from FormatCommandLine.zip.