I want to use an async AG to test SQL server migration on SQL server 2017 standard edition. There are 50 databases so the plan is to configure 1 AG per db in the async mode without WSFC.
To test the migration works OK I want to deactivate the AG and activate the databases on the server to test that my apps can connect to the database and everything runs OK.
However, the only option I see in AG is to do the failover but this is not exactly what I want. I want the primary to remain the primary. And the secondary to be a separate sql server on which I can test my applications. Is this possible using an AG?