dsccommunity / dsccommunity/SqlServerDsc
SqlInstall: New resource proposal
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files or tests are named. Start by reviewing the existing SqlSetup properties and the listed command entry points: Install-SqlDscServer, Repair-SqlDscServer, Uninstall-SqlDscServer, Complete-SqlDscImage, Complete-SqlDscFailoverCluster, and Initialize-SqlDscRebuildDatabase. Done would require a class-based SqlSetup resource covering standalone and cluster installation, repair, removal, image completion, and failover configuration.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases, devops
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100