Copy-DBALogin - does not copy "other" settings - eg Language #9638
Description
Verified issue does not already exist?
I have searched and found no existing issue
What error did you receive?
While migrating accounts between one server and another using copy-dbalogin, it was found that at the destination, dates were being displayed wrong to the users. This has been traced to the language being set to us_english when the source system account is set to British English...
I have trawled through the code on here - a call is made to new-dbalogin, which will accept a language option, however, that isn't captured from the source system - and added to the splat, so it defaults to us_english
Steps to Reproduce
create a Login and set a language to other than us_english on a source server, copy that to a new server using
copy-dbalogin -source @source -destination @destination -Login @login
Check the account on the destination once run
Please confirm that you are running the most recent version of dbatools
2.1.6
Limited on downloads - however I have checked the published source on here
Other details or mentions
No response
What PowerShell host was used when producing this error
Windows PowerShell ISE (powershell_ise.exe)
PowerShell Host Version
Name Value
PSVersion 5.1.22621.4391
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.22621.4391
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1
SQL Server Edition and Build number
various
.NET Framework Version
.NET Framework 4.8.9290.0