Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.
This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.
Author(s)
Duane Brown
Authoring Organization(s)
CEDS
Email Address
duane.brown@aemcorp.com
Use Case Title
Release Data Warehouse scripts in lower version of SQL. Change the compatibility level to less than 150 (2019). Perhaps in the 2012 or 2016 range.
Use Case Overview
Current release script requires SQL Server Management Studio 2019. Change the compatibility level to less than 150 (2019). Perhaps in the 2012 or 2016 range.
This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.
Author(s) Duane Brown
Authoring Organization(s) CEDS
Email Address duane.brown@aemcorp.com
Use Case Title Release Data Warehouse scripts in lower version of SQL. Change the compatibility level to less than 150 (2019). Perhaps in the 2012 or 2016 range.
Use Case Overview Current release script requires SQL Server Management Studio 2019. Change the compatibility level to less than 150 (2019). Perhaps in the 2012 or 2016 range.