SQL Server database schema validation, deployment, and upgrade runtime. Enables declarative database development and database portability across SQL Server versions and environments.
Environment (local platform and source/target platforms):
Steps to Reproduce:
We were able to remove the unsupported Sql permission statements from the deployment/import
We need to add these three cases
i. Revisit the permissions list and update SqlPlatform to any missing permission.
ii. Add a condition that checks object kind for the permissions, some similar permissions are shared between the objects but some are supported, and some are not.
iii. Add a user display message when we are not supporting that specific permission.
Did this occur in prior versions? If not - which version(s) did it work in?
Steps to Reproduce:
Did this occur in prior versions? If not - which version(s) did it work in?
(DacFx/SqlPackage/SSMS/Azure Data Studio)