Stretch Database

GPTKB entity

Statements (41)
Predicate Object
gptkbp:instanceOf gptkb:database
gptkbp:benefit reduce on-premises storage costs
seamless access to remote data
gptkbp:deprecatedIn gptkb:SQL_Server_2022
gptkbp:developedBy gptkb:Microsoft
gptkbp:enables hybrid cloud storage
https://www.w3.org/2000/01/rdf-schema#label Stretch Database
gptkbp:introducedIn gptkb:SQL_Server_2016
gptkbp:limitation no support for check constraints on stretched tables
no support for identity columns on stretched tables
no support for unique constraints on stretched tables
no support for full-text indexes on stretched tables
no support for nonclustered indexes on stretched tables
no support for computed columns on stretched tables
does not support all table types
limited indexing on stretched tables
no support for CDC on stretched tables
no support for FILESTREAM data
no support for In-Memory OLTP tables
no support for XML indexes on stretched tables
no support for change tracking on stretched tables
no support for columnstore indexes
no support for foreign keys on stretched tables
no support for merge replication
no support for replication on stretched tables
no support for service broker
no support for spatial indexes on stretched tables
no support for temporal tables
no support for triggers on stretched tables
no support for clustered indexes on stretched tables
no support for default constraints on stretched tables
no support for CHECK constraints on stretched tables
no support for table partitioning on stretched tables
gptkbp:partOf gptkb:Microsoft_SQL_Server
gptkbp:purpose migrate cold or historical data to Azure
gptkbp:status deprecated
gptkbp:storage gptkb:Azure_SQL_Database
on-premises SQL Server
gptkbp:supports row-level data movement
gptkbp:bfsParent gptkb:SQL_Server_2016
gptkbp:bfsLayer 7