Product: PowerShell Universal
Version: 5.3.2
We’re attempting to migrate our PSU database from SQLite to MS SQL server, but when we do, we’re getting an unhandled DotNet exception:
Unhandled exception. System.ArgumentException: An item with the same key has already been added. Key: -scn
at System.Collections.Generic.Dictionary`2.TryInsert(TKey key, TValue value, InsertionBehavior behavior)
at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
at System.CommandLine.Parsing.StringExtensions.ValidTokens(Command command)
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 System.CommandLine.Parsing.ParserExtensions.InvokeAsync(Parser parser, String[] args, IConsole console)
at PSUCLI.Program.Main(String[] args) in C:\actions-runner\_work\universal\universal\src\Universal.CommandLine\Program.cs:line 67
at PSUCLI.Program.<Main>(String[] args)
This happens at any point where the migrate command is included, even with psu db migrate --help.
I put in a ticket (#10373) hoping to get support, but (and I don’t want to make any assumptions) the responses strongly feel like the agent is copying my replies and pasting them straight into ChatGPT. The last response recommended that we manually migrate our database to MS SQL, including “Adjust[ing] the SQL dump to be compatible with MS SQL server, addressing differences in data types and syntax”, which doesn’t seem like an acceptable solution. It seems somewhat unreasonable for me to need to be an expert on PSU’s database schema to migrate an internal DB.
Any help with this would be appreciated. We’re looking to move to a HA setup this quarter and this is a prerequisite.