The CEDS Integrated Data Store factors the entities and attributes of the CEDS Domain Entity Schema (DES) with standard technical syntax and 3rd normal form database normalization. The IDS Logical Model provides a standard framework for integration of P-20 data systems through a well-normalized “operational data store”. In a P-20 data system, the IDS models the most current view of data available to the enterprise, including some historical data (such as prior assessment data and enrollment records). A “record” is generally added for each Person-Organization Relationship change event in the system. This CEDS logical model does not directly address the production aspects of log and change management.
Describe the bug
There are a few instances of SQL statements that have different capitalization than Database Projects expect in Visual Studio and they generate warnings when building a project. Having the ability to build fresh installs without warnings makes the installation process easier for new adopters.
To Reproduce
Steps to reproduce the behavior:
Create a new database instance following the existing instructions.
Create a new Database Project in Visual Studio (tested in 2019 and 2022).
Import the schema into the project in VS
Build the project
You can see multiple warnings related to unexpected capitalization
Expected behavior
A fresh install should allow for a simple import and build without errors or warnings.
Screenshots
Available on request.
Desktop (please complete the following information):
OS: Windows 10 Enterprise
Visual Studio 2019 or 2022
Tested on SQL Server 2016/2019 (on-premises) and Azure SQL Server 2019
Additional context
Proposed changes are included in Pull Request #64
Describe the bug There are a few instances of SQL statements that have different capitalization than Database Projects expect in Visual Studio and they generate warnings when building a project. Having the ability to build fresh installs without warnings makes the installation process easier for new adopters.
To Reproduce Steps to reproduce the behavior:
Expected behavior A fresh install should allow for a simple import and build without errors or warnings.
Screenshots Available on request.
Desktop (please complete the following information):
Additional context Proposed changes are included in Pull Request #64