I'm planning to set up a new SQL Server 2017 Standard Edition instance, with Basic Availability Groups. How can I test that in a dev or qa environment?
In my QA environment now, I have Developer edition installed. When I run the T-SQL to create a Basic Availability Group, I get the following error:
'BASIC' failed because it is not supported in the edition of this SQL Server instance
I've learned that Developer and Evalualtion have same feature set as Enterprise, so looks like I can't use those? Do I need a fully licensed Standard edition in a dev/qa environment to test Basic Availability Groups?