Looking for best option(s) to have near real-time data synced from SQL Managed Instance to another SQL Managed Instance

I have two SQL Managed Instances 1 - Primary Production 2 - Reporting / Analytic workloads Besides traditional SQL replication (transactional) what is the best way to get data in near real-time from the primary to the secondary server. The secondary is not used in HA or DR at all and only for reporting workloads that we don't want to run on the primary managed instance. My problem with transactional replication is certain tables in the primary instance are truncated which complicates replication. I also don't want to have to drop publications and generate snapshots, impacting the production applications. Log shipping would be an option but it disables the database on the secondary while restoring and isn't nearly real-time.   Really what I'm looking for is something like AG, which doesn't appear to be available in same region servers, unless I'm wrong. Researching Managed Instance Link seems perfect, except I'm not seeing that the source can be a Managed Instance, unless I'm wrong. The target database on the secondary can be read-only if needed.