SQL Server 2016 Stretch Database

Question

SQL Server 2016 Stretch Database

suresh_yaram

SSC Veteran

Points: 267
More actions
November 15, 2015 at 11:28 pm

#322315

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

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

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

Thom A SSC Guru Points: 99133 More actions · Answer 1

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.

Thom~

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

suresh_yaram SSC Veteran Points: 267 More actions · Answer 2

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

jfogel SSCarpal Tunnel Points: 4155 More actions · Answer 3

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.

Cheers

Misha_SQL SSCertifiable Points: 5407 More actions · Answer 4

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 More actions · Answer 5

akljfhnlaflkj

SSC Guru

Points: 76202

November 16, 2015 at 12:54 pm

#1840104

Sounds like a great feature.

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 6

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 More actions · Answer 7

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)