SQL Server 2016 Stretch Database

  • suresh_yaram

    SSC Veteran

    Points: 267

    Comments posted to this topic are about the item SQL Server 2016 Stretch Database

  • Thom A

    SSC Guru

    Points: 98622

    Does anyone know what edition this is likely to be shipped with? I'm guessing enterprise, but I can live in hope that it might be the BI or Standard.


    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • suresh_yaram

    SSC Veteran

    Points: 267

    My understanding too is, it will be shipped with Enterprise edition only

  • jfogel

    SSCarpal Tunnel

    Points: 4132

    This sounds kind of useless to me. All the rules and the probability of Enterprise-only make this of little to no use at all.


  • Misha_SQL


    Points: 5388

    Thank you for the article!

    Do I understand correctly that the entire table marked with REMOTE_DATA_ARCHIVE = ON will be migrated into the cloud (storage-wise)? If so, it seems the only real way to use it would be to have a "live" table and a separate "archive" table, with "live" table being local and "archive" table being in the cloud. In addition, there would need to be some sort of process moving data between the tables. Oh, and it seems the "stretching" is not supported at the individual partition level yet, which would be ideal.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Sounds like a great feature.

  • curious_sqldba


    Points: 36302

    Nicely written:)

    While the feature looks cool, something are not clear:

    i) What is the criteria for moving the data from on-premise to cloud? Does Azure make its own decision or can we control which set of data goes in Azure?

    iii) This "Uniqueness is not enforced via UNIQUE constraints and PRIMARY KEY constraints on a Stretch-enabled table" is a big bummer i think, sounds like this is great for a denormalized schema. If i have a table with PK's,lets say part of it goes to Azure , how would i even tick & tie the records where there is no PK in Azure ?

  • suresh_yaram

    SSC Veteran

    Points: 267

    As of CTP 2.x, we can not set filter on the records to be moved to Cloud. Complete table will be archived to cloud. It is expected that the RTM version will support this (as stated in Microsoft website)

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply