Forum Discussion
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 t...
Idrissshatila
Super User
Super UserHello rdslvbg ,
in your case you could use incremental refresh, to set refresh for a certain time and archive the historical data.
learn more about incremental refresh here https://youtu.be/Kui_1G6kQIQ?si=_qRYLeHHoXYmRTIR