StretchDB is a feature that enables us to store data from tables placed in on-premise databases to cloud. A typical scenario is when users keep data forever, but rarely access it. Such historical tables with huge amounts of records tend to run out of space and also maintenance requirements such as backup size becomes an issue. In other words, StretchDB is intended for cold OLTP data. It's not a good idea to stretch data warehouse tables even if they are big.
StretchDB offers a transparent way of data movement to a dedicated Azure SQL database. All data could be moved, but also the filter function can be written to decide how many records will stay on-premise. Everything is set up on the SQL Server site, the only requirement is to ...
