New Support for Contained Availability Groups

[serenefiresiren]

Type of Change

• [ ] Bug fix (non-breaking change, fixes # )
• [x] New feature (non-breaking change, adds functionality, fixes #8713 )
• [ ] Breaking change (affects multiple commands or functionality, fixes # )
• [ ] Ran manual Pester test and has passed (.\tests\manual.pester.ps1)
• [ ] Adding code coverage to existing functionality
• [ ] Pester test is included
• [ ] If new file reference added for test, has is been added to github.com/dataplat/appveyor-lab ?
• [ ] Unit test is included
• [ ] Documentation
• [ ] Build system

Purpose

SQL Server 2022 added support for contained availability groups.

Approach

The New-DbaAvailabilityGroup leverages the built-in ReuseSystemDatabses and IsContained parameters to facilitate both the initial build and a recreation with previously provisioned contained databases.

Commands to test

Work in progress

Learning

What is a contained availability group? New-SQLAvailabilityGroup SMOObject

[serenefiresiren]

Thanks for the feedback! I'll get these fixed Monday.

[potatoqualitee]

Thank you both 🙏🏼 Will fix encoding issue once changes are complete, just prior to merge.

[DorBreger]

https://github.com/serenefiresiren/dbatools/pull/2

[andreasjordan]

Sorry, still not correct. Please have a look at the other parameter tests.

[andreasjordan]

#9352 has all the needed changes, so we should close this one.

[potatoqualitee]

thank you all 🙏🏼 will merge for credit and fix all issues in next PR