I have a database that stores high frequent data, the data has a complex data model. Now I want to offload/archive this data in 15 minute intervals to another database server so user can do reporting on this data with a minimal delay. To improve performance I don't want to keep more than 2 days of data on the primary system. In a previous version of this system the data model was very simple so I used SSIS and transfered data from two tables based on a time stamp, however now with the complex data model I have some doubts that this approach will be efficient.
What strategies would be best for such an environment ? HADR would be nice, however with the deletion of the date on the primary it won't work since I want to keep all data on the reporting instance.