Microsoft.VisualStudio.Component.SQL.SSDT update request #13678
Description
Tool name
Microsoft.VisualStudio.Component.SQL.SSDT
Tool license
Add or update?
- Add
- Update
Desired version
latest
Approximate size
No response
Brief description of tool
This is SQL Data Tools inside Visual Studio,
Current Microsoft.VisualStudio.Component.SQL.SSDT in runners has the DacFx(Microsoft.Data.Tools.Schema.Sql.dll) Version 162.x, this does not support building projects with JSON_OBJECTAGG.
Microsoft.VisualStudio.Component.SQL.SSDT containing DacFx with version 170.x is needed to build such projects.
URL for tool's homepage
No response
Provide a basic test case to validate the tool's functionality.
//Build A project with JSON_OBJECTAGG syntax in use
create function fn_test_01() returns nvarchar(MAX) as
begin
return (select json_objectagg(KeyName:ValueString absent on null)
from PropertyChanges);
end;
//KeyName, ValueString are columns in PropertyChanges Table.Platforms where you need the tool
- Azure DevOps
- GitHub Actions
Runner images where you need the tool
- Ubuntu 22.04
- Ubuntu 24.04
- Ubuntu Slim
- macOS 14
- macOS 14 Arm64
- macOS 15
- macOS 15 Arm64
- macOS 26
- macOS 26 Arm64
- Windows Server 2022
- Windows Server 2025
- Windows Server 2025 with Visual Studio 2026
Can this tool be installed during the build?
Tool installation time in runtime
No response
Are you willing to submit a PR?
No response