Strategies to archive high frequent data in SQL Server 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.
If performance is your only consideration if I were you I would consider partitioning your table(s) rather than just deleting the data.  Then you could look into either log shipping (if you want the whole database to be updated) or replication (if you only want a couple of tables copied).  As an alternative you could look into change data capture as a method of storing the changes you are making to the data.  You can then pull this information out to apply it to your other database.