SQL Server Stretch database, and archiving table to SQL Azure
Stretch table could be good fit for your need. However i suggest to check the current limitations of enabling stretch feature. 

https://msdn.microsoft.com/en-us/library/mt605114.aspx

The other manual way of doing this is partitioning the table and switching out to another table in the same DB.