search

dataplat / dbachecks

✔ SQL Server Environmental Validation
https://dbachecks.readthedocs.io/en/latest/
MIT License
460 stars 141 forks source link

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

Open MikeyBronowski opened 10 months ago

MikeyBronowski commented 10 months ago

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