1 have 2 sql servers.
Svr1 is enterprise edition and Svr2 is standard edition.
Both have their own independant FCI.
Svr1 has got 60 production dbs. Svr2 has got 10 reporting dbs and multiple etls.
Presently the etls running on Svr2 fetch data from 5 dbs from Svr1 and insert data into one/more reporting dbs on Svr2.
I want to sync 5 dbs from Svr1 into Svr2 so that reporting tools and etl on Svr2 has access to copy of those dbs on Svr2 itself.
The sync need not be real time and a delay of 15 minutes is acceptable.
I am exploring SQL AG asynchronous with readable secondary for this.
It says: Basic AG - No read access on secondary replica. But in my case the primary is enterprise which I assume means that the AG that I create is not basic but full fledged AG. I'm not able to get documentation regarding this that- what a AG is basic and when it is not basic.
This link says about the readable secondary that I am talking about: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-scale-availability-groups?view=sql-server-ver16
But there is no information about license on the secondary server.
Does enterprise edition primary and standard edition secondary support readable secondary?
Have I understood correctly that I can't create a group of 5 AG, instead I need to create 5 separate AGs because my secondary is having standard license?