Dbatools configuration profiles

Summarize Functionality

Right now, we default a few configurations that are meant to be for pure interaction and not automation (non-interactive) uses with the module. Big example is the TEPP configuration, by default tabexpansion.disable is set to false.

The average use of our module I think now-a-days is purely non-interactive. Those that use it for interactive purposes to check things here-and-there is less than those writing scripts and automating workflows against SQL Server.

I think one of two things can be done:

We default all configurations to assume non-interactive use of the module, those that want to perform interactive task can enable features if they want but we cater to automation and non-interactive sessions by default.
Create a parameter on Set-DbatoolsConfig to allow for two profiles: interactive and non-interactive.

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

Yes

Technical Details

If we go the route of profiles...

Create a parameter that would be used like: Set-DbatoolsConfig -Profile Interactive or Set-DbatoolsConfig -Profile NonInteractive

The workflow for each parameter value would set the associated configurations to disable (NonInteractive) or enable (Interactive).

We have some values that for example the configuration item is to disable it, so by default it is enabled (Get-DbatoolsConfig -Module tabexpansion). In the scenario of non-interactive, that profile would set tabexpansion.disable to true, and opposite the interactive profile setting this would be set to false.

dataplat / dbatools