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
|