dsccommunity / dsccommunity/SqlServerDsc
SqlAGSyncLogins: New resource proposal
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
Consider creating a resource to synchronise Logins between nodes of an AG
Looks at all nodes in a specified AG
Looks at all DBs in a specified AG
Looks for any login in any DB in the Primary node of the specified AG
Copies the login from primary AG node to all secondaries
Could be used to sync both Windows and SQL logins?
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
Start by reviewing the existing SqlServerDsc resources and entry points for availability groups, databases, and logins. Clarify whether the resource must support Windows logins, SQL logins, or both, and define how primary and secondary nodes are identified. Done means the synchronization behavior and supported login types are specified well enough to implement and test.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100