microsoft / microsoft/sqlmanagementobjects
Availability Group Script does not include ReadOnly Routing List, etc.
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 143
- Forks
- 28
- PR merge metrics
- No merged PRs in 30d
Description
When scripting out the availability group or its replicas, I get the Read_Only_routing_url but I do not get the Read_Only_Routing_List nor do I get my Read_Write_Routing_Url when it is set.
Is that by design? If I wanted to document my AG setup, I would be missing pieces and have to get them from the DMVs or create my own version of the script.
I would love to be able to get a complete AG definition that includes these 2 items.
Thanks
Contributor guide
No contributing guide indexed for this repository
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 locating the availability-group and replica scripting entry points in the SQL Management Objects code, then compare the generated definition with the routing settings described in the issue. Done means scripting includes the Read_Only_Routing_List and configured Read_Write_Routing_Url so the AG definition is complete.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100