Currently stretch database in SQL Server 2016 moves the entire table to Azure. However, this InfoQ article mentions an "archive row" mode for Stretch database that will allow you to filter which rows in a table to move to the cloud (ex. records before 2010). I haven't been able to find any official Microsoft documentation regarding this unreleased feature.

Can someone point me to an official source that says this is coming for RTM? I did find a French blog entry on MSDN mentioning it but nothing else.


Documented now for the latest CTP release. See how to write a TVF that a filter predicate uses to define what is a cold row (that gets moved) in a table with a mix of hot & cold rows: https://msdn.microsoft.com/en-us/library/mt613432.aspx

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.