sql-action
sql-action copied to clipboard
sqlpackage path argument, dotnet tool sqlpackage
3 changes lumped together in this PR (I let it get away from me):
- for dacpac and sqlproj action there's an optional action parameter
sqlpackage-pathwhich overrides any sqlpackage location detection by the action except to check that it exists. - dotnet tool location for a global install of sqlpackage is checked
- the full semantic version is parsed for version comparison, instead of just 150 vs 160, which was leading to the wrong version being picked (162.1 vs 162.2 would default to one based on who installed instead of the actual version)
future PR needed to remove SSMS-related logic as it hasn't installed sqlpackage.exe for quite some time