SQL Server Tools not supporting in VS2019

ejameslee3

I am using Visual Studio 2019 and trying to create SQL Change Automation Project but throwing error " The Target Platform for this project is not support by the installed SQL Server Tools." . Followed the link and installed the sql tools from the link but it does not working.
(same issue, but for VS2019, as: https://forum.red-gate.com/discussion/86464/sql-server-tools-not-supporting-in-vs2015)

DanC

Hi @ejameslee3

Could you show me the about page for the version details of VS 2019 you're using?

ejameslee3

Microsoft Visual Studio Professional 2019

Version 16.11.38

VisualStudio.16.Release/16.11.38+35026.282

Microsoft .NET Framework

Version 4.8.09037

Installed Version: Professional

.NET Core Debugging with WSL   1.0

.NET Core Debugging with WSL

ASP.NET and Web Tools 2019   16.11.119.57942

ASP.NET and Web Tools 2019

ASP.NET Web Frameworks and Tools 2019   16.11.119.57942

For additional information, visit https://www.asp.net/

Azure App Service Tools v3.0.0   16.11.119.57942

Azure App Service Tools v3.0.0

Azure Functions and Web Jobs Tools   16.11.119.57942

Azure Functions and Web Jobs Tools

C# Tools   3.11.0-4.22108.8+d9bef045c4362fbcab27ef35daec4e95c8ff47e1

C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Common Azure Tools   1.10

Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

Devart SQL Complete   6.16.4

Devart dbForge SQL Complete for Management Studio and Visual Studio

Copyright (c) 2017 Devart. All rights reserved.

Web: http://www.devart.com/dbforge/sql/sqlcomplete 

Support: http://www.devart.com/dbforge/sql/sqlcomplete/support.html 

Ordering: http://www.devart.com/dbforge/sql/sqlcomplete/ordering.html 

IntelliCode Extension   1.0

IntelliCode Visual Studio Extension Detailed Info

Microsoft Azure Tools for Visual Studio   2.9

Support for Azure Cloud Services projects

Microsoft Continuous Delivery Tools for Visual Studio   0.4

Simplifying the configuration of Azure DevOps pipelines from within the Visual Studio IDE.

Microsoft JVM Debugger   1.0

Provides support for connecting the Visual Studio debugger to JDWP compatible Java Virtual Machines

Microsoft Library Manager   2.1.126+g11d4cf0d0c.RR

Install client-side libraries easily to any web project

Microsoft MI-Based Debugger   1.0

Provides support for connecting Visual Studio to MI compatible debuggers

Microsoft Visual Studio Tools for Containers   1.2

Develop, run, validate your ASP.NET Core applications in the target environment. F5 your application directly into a container with debugging, or CTRL + F5 to edit & refresh your app without having to rebuild the container.

NuGet Package Manager   5.11.5

NuGet Package Manager in Visual Studio. For more information about NuGet, visit https://docs.nuget.org/

ProjectServicesPackage Extension   1.0

ProjectServicesPackage Visual Studio Extension Detailed Info

Razor (ASP.NET Core)   16.1.0.2122504+13c05c96ea6bdbe550bd88b0bf6cdddf8cde1725

Provides languages services for ASP.NET Core Razor.

SQL Server Data Tools   16.0.62205.05200

Microsoft SQL Server Data Tools

SQL Server Reporting Services   15.0.19528.0

Microsoft SQL Server Reporting Services Designers 

Version 15.0.19528.0

TypeScript Tools   16.0.30526.2002

TypeScript Tools for Microsoft Visual Studio

Visual Basic Tools   3.11.0-4.22108.8+d9bef045c4362fbcab27ef35daec4e95c8ff47e1

Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Visual F# Tools   16.11.0-beta.21514.6+b6c2c4f53ea3a08fa603ea93d6d2f808a62a21d1

Microsoft Visual F# Tools

Visual Studio Code Debug Adapter Host Package   1.0

Interop layer for hosting Visual Studio Code debug adapters in Visual Studio

Visual Studio Container Tools Extensions   1.0

View, manage, and diagnose containers within Visual Studio.

Visual Studio Tools for Containers   1.0

Visual Studio Tools for Containers

DanC

Hi @ejameslee3

Thank you for providing that update!

I also upgraded to using 16.11.38 and didn't experience this issue, are you using the latest version of SQL Change Automation?

https://download.red-gate.com/checkforupdates/SQLChangeAutomation/SQLChangeAutomation_4.6.24200.3823.exe

ejameslee3

Hi @DanC
I downloaded and installed the latest version of the SQL Change Automation tool from the link you had provided above, but still get the same error:

ejameslee3

@DanC
Question - I also have VS2022.  On VS2022, this error does not appear.  But does having more than one version cause this issue?

DanC

Hi @ejameslee3

That's really strange, I'm a little stumped on this one to be honest!

I also have VS2019 & VS2022, and I'm not getting this issue, so it's an odd one!

I'm going to create a github ticket for the developers to investigate this one

ejameslee3

Thank you @DanC
I'll sit tight for what is discovered.

cperez

 Hi @ejameslee3,

Replying on this on DanC's behalf as he is out currently.

Seems our developers are having trouble replicating this behavior but development came across the following article and are asking if you have had already tried these steps as we think they may be helpful in rectifying this error.

https://littlekendra.com/2018/10/03/sql-change-automation-visual-studio-and-the-unknown-sql-server-platform-error/

Let us know if the above helps you.