[FR] Export-DbcConfig - add option to create folders if they don't exist

[MikeyBronowski]

Feature Request

<-- Simply answer the question - What would you like dbachecks to do that it doesn't? -->

Current behaviour

Export-DbcConfig -Path C:\Tools\PowerDBA\dbachecks_config.txt -Force
Out-File: Could not find a part of the path 'C:\Tools\PowerDBA\dbachecks_config.json'.

New requested behaviour

Use the new switch to create the folder structure first: -CreatePath, -ForceCreate or whatevs

Export-DbcConfig -Path C:\Tools\PowerDBA\dbachecks_config.txt -Force -CreatePath

Add something like New-Item when the switch is enabled.

Get-DbcConfig |
 Select-Object * |
 ConvertTo-Json -Depth 10 |
 Out-File ( New-Item -FilePath $Path -Force ) -Force -ErrorAction Stop

https://github.com/dataplat/dbachecks/blob/6b633310b71ff982ae5dd9b8658308e0cf7d6daf/source/functions/Export-DbcConfig.ps1#L54C9-L54C9