Configure Replication or AlwaysOn in SQL 2019 Standard

If you need always current data - then your options are replication or Azure Data Sync (there are quite a few requirements for this).

The only other option for near real-time access to a read-only copy would be upgrading to Enterprise Edition and setting up an AG.

2 Likes