How can we help you today? How can we help you today?

SQL Server Tools not supporting in VS2019

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)
ejameslee3
0

Comments

8 comments

Sort by
  • DanC
    Hi @ejameslee3

    Could you show me the about page for the version details of VS 2019 you're using?
    DanC
    0
  • 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.

    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
    ejameslee3
    0
  • 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
    DanC
    0
  • 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
    0
  • ejameslee3
    @DanC
    Question - I also have VS2022.  On VS2022, this error does not appear.  But does having more than one version cause this issue?
    ejameslee3
    0
  • 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
    DanC
    0
  • ejameslee3
    Thank you @DanC
    I'll sit tight for what is discovered.
    ejameslee3
    0
  • 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.

    cperez
    0

Add comment

Please sign in to leave a comment.