I want to create a SQL Database project and manage my database as code (e.g. DevOps), but I am not sure what tools I can use for free within an enterprise.
How do I install and use SSDT without requiring paid licensing and violating any EULAs, such as Visual Studio Community Edition's?
In enterprise organizations (meaning those with >250 PCs or > $1M in annual revenue) no use is permitted...
This Microsoft article states that I can use SSDT in VS2019, but it doesn't tell me how to install it and not violate EULA.
This SSDT Download page is unhelpful and does not provide anything about licensing.
Also, I considered other tools, but looking at docs they don't seem comparable to SSDT:
- Azure Data Studio - (cross-platform) new preview extension SQL Database Project supports DACPAC. I wasn't happy with my previous trial of this product. Maybe I'll give it another try in a couple years.
- VS Code: Does not appear to have any extensions that directly support a SQL Database Project and/or DACPAC
