Copy-DbaSpConfigure
This command copies configuration values (sp_configure) from one SQL Server to another. By default, all configuration values are copied.
The -Configs parameter is autopopulated for command-line completion and can be used to copy only specific configs.
Examples
To copy all sp_configure settings from sqlserver2014a to sqlcluster using integrated (Windows) authentication
1 |
Copy-DbaSpConfigure -Source sqlserver2014a -Destination sqlcluster |
To update the values for two configs, the IsSqlClrEnabled and DefaultBackupCompression, from sqlserver2014a to sqlcluster, using SQL credentials for sqlserver2014a and Windows credentials for sqlcluster
1 |
Copy-DbaSpConfigure -Source sqlserver2014a -Destination sqlcluster -Configs DefaultBackupCompression, IsSqlClrEnabled -SourceSqlCredential $cred -Force |
To see what would happen if the command were executed
1 |
Copy-DbaSpConfigure -Source sqlserver2014a -Destination sqlcluster -WhatIf |