Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Modify creation scripts to avoid version-specific or installation specific clauses #76

Open
rushj4 opened this issue Apr 5, 2024 · 0 comments

Comments

@rushj4
Copy link

rushj4 commented Apr 5, 2024

Current database creation scripts include some options that may make it difficult to run or evaluate changes.

For example, table creation scripts contain the clause "OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF"; this is only valid for SQL 2019 and above, and will cause the table create to fail if run on SQL 2017 or earlier. Since Off is the default setting, removing the clause should have no effect on SQL 2019 and above systems.

Also, we find data compression settings on many tables and indexes. These would seem to be installation specific, and when included may generate false change reports when comparing Current CEDS to our installation. Similarly, please ensure all keys, constraints, and defaults are named; we want to avoid generated names showing as differences.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant