I have a production database (SQL server 2016) which is hosted on an Azure VM. We have set up a log shipping (every 15 mins) onto another Azure VM which is a read replica and would act as a DR system. The team also makes use of this DB for their quick reporting needs.
But since it is a read replica team will not be able to create any tables in it for reporting purpose. So looking for a way to get real-time data from production DB on a periodic basis but also it has to be writable so that teams can dip into it for all their quick reporting needs.