Historical data (replica) & prod data (current)

Hey,

I turn to you with a question that is hard for me.
Sample description of my problem.

I have 3 years of data and it is replicated to a separate MSSQL server. The data is usually up to 4am today.

I have the same data in the production database of the app, they are updated on a regular basis (new data comes in)

I need to build a report that includes a table displaying data from the replica (which I want to import once a day in the morning) and data from the production that is not in the replica (which appeared after 4 am)

How can I query the production of tane from the whole day at the same time displaying data from the replica (there are about 500,000 rows). The data from production should download every time the user filters (and only the data from production, the imported data is to remain unchanged)

I am very much asking for help