SqlInstall: New resource proposal #2175
Description
Resource proposal
A class-based SqlSetup resource would manage SQL Server installation, repair, uninstallation, image completion, and failover cluster configuration. It would internally use commands such as Install-SqlDscServer, Repair-SqlDscServer, Uninstall-SqlDscServer, Complete-SqlDscImage, Complete-SqlDscFailoverCluster, and Initialize-SqlDscRebuildDatabase. This resource would simplify and standardize cluster and setup management for SQL environments.
Proposed properties
| Property | Type qualifier | Data type | Description | Default value | Allowed values |
|---|---|---|---|---|---|
| Ensure | Key | String | Whether SQL Server should be Present or Absent | Present | Present, Absent |
| InstanceName | Key | String | The name of the SQL Server instance | None | Any valid instance name |
| Features | Write | String[] | Features to install (e.g., SQL, AS, RS) | None | Feature list |
| MediaPath | Write | String | Path to installation media | None | Any valid path |
Should support the properties of SqlSetup.
Special considerations or limitations
Contributor should consider supporting both standalone and cluster installs, all supported SQL Server versions, and proper error handling for setup failures. Limitations may include platform-specific behaviors and the need for elevated permissions to install SQL Server.