Skip to content

Consider adding a script for Ledger Module #66

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

Closed
Datachick opened this issue Apr 17, 2023 · 1 comment
Closed

Consider adding a script for Ledger Module #66

Datachick opened this issue Apr 17, 2023 · 1 comment

Comments

@Datachick
Copy link

Consider adding a script or to the script about controlling DDL changes to Ledger Tables. This could show the sorts of "normal" table ALTERs that can be done: certain datatype changes, adding columns, removing columns, etc.

This might help alleviate the concerns by devs and DBAs that Ledger tables are set in stone.

@rgward
Copy link
Member

rgward commented Apr 23, 2023

thanks for the suggestion but there are a lot of exercises already in the module. What I will do is summarize a few things from this part of the doc that talks about what is allowed or not allowed for schema changes: https://learn.microsoft.com/en-us/sql/relational-databases/security/ledger/ledger-limits?source=recommendations&view=sql-server-ver16#schema-changes-consideration

@rgward rgward closed this as completed Apr 23, 2023
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

2 participants