microsoft
Deploy and compare a specific schema instead of a full database for Azure Synapse
Is your feature request related to a problem? Please describe. With Azure SQL Synapse, multiple teams owns multiple schemas and each team wants to compare/deploy individual schema.
We have an increased need to deploy specific schema's instead of a full database, for more granular deployments. More controllable impact, less impact on the whole database.
Describe the solution you'd like It would be great if there is out-of-the-box support for deploying a specific schema, instead of a full database. Hopefully as a side-effect schema compares will also speed up as only specific schema's need to be checked.
Describe alternatives you've considered A clear and concise description of any alternative solutions or features you've considered.
Additional context Add any other context or screenshots about the feature request here.
100% on this. We’re very happy that Azure Synapse (formerly SQLDW) is under the SSDT umbrella but the development patterns (many schemas/many teams) for large orgs still cause quite a bit of pain.
