November 15, 2015 at 11:28 pm
Comments posted to this topic are about the item SQL Server 2016 Stretch Database
November 16, 2015 at 2:50 am
My understanding too is, it will be shipped with Enterprise edition only
November 16, 2015 at 8:57 am
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
November 16, 2015 at 9:39 am
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.
November 16, 2015 at 12:54 pm
Sounds like a great feature.
November 17, 2015 at 8:37 am
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 ?
November 18, 2015 at 8:01 am
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 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply