Backup-DbaDbMasterKey - Support Custom Backup File Name

[serenefiresiren]

Summarize Functionality

SQL Command allows specifying the file name when backing up the service master key. Backup-DbaDbMasterKey currently automatically sets the filename. It would be nice to have the option here as well.
Relates to #9485, #9483

Is there a command that is similiar or close to what you are looking for?

Yes

Technical Details

SQL

USE [YourDB];   
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'DecryptionPassword';   
BACKUP MASTER KEY TO FILE = 'c:\temp\exportedmasterkey.key'   
    ENCRYPTION BY PASSWORD = 'EncryptionPassword';  

Existing File name command, Line 147
$filename = Join-DbaPath -SqlInstance $server -Path $actualPath -ChildPath "$fileinstance-$dbname-masterkey.key"

Suggested change adding an option Filename parameter

param (
        [DbaInstanceParameter[]]$SqlInstance,
        [PSCredential]$SqlCredential,
        [PSCredential]$Credential,
        [string[]]$Database,
        [string[]]$ExcludeDatabase,
        [Alias("Password")]
        [Security.SecureString]$SecurePassword,
        [string]$Path,
       **[string]$ChildPath,
       [Alias("FileName")]**
        [parameter(ValueFromPipeline)]
        [Microsoft.SqlServer.Management.Smo.Database[]]$InputObject,
        [switch]$EnableException
    )
#
#
#
# pseudo
$ChildPath = $ChildPath or if null then "$fileinstance-$dbname-masterkey.key"` 
$filename = Join-DbaPath -SqlInstance $server -Path $Path -ChildPath $ChildPath 

[wsmelton]

Is there any difference to you just running Rename-Item after the command?

[serenefiresiren]

See #9485 for discussion