Tool information

• Tool name: SQL Server Data Tools
• Add or update? Update
• Desired version: SQL Server Data Tools 2017 (or later)

Question, Bug, or Feature?:
When I create a local instance of LocalDB on build agents from the 'windows-2019' specification, the agents appear to be running SQL Server Data Tools 2016 (version 13.1.4001.0)

sqllocaldb create MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" created with version 13.1.4001.0. <--SSDT 2016

My database deployment scripts requires SSDT 2017 (or later), because they contains newer in-built functions like TRIM(), LEFT(), etc... that were only introduced in SSDT 2017.

LocalDB instance "MSSQLLocalDB" created with version 14.0.3238.1 <-- SSDT 2017

Would it be possible to install SSDT 2017 (or later) on these build agents?

Thanks in advance,

Virtual environments affected

• macOS 10.15
• Ubuntu 16.04 LTS
• Ubuntu 18.04 LTS
• Windows Server 2016 R2
• Windows Server 2019