sql-servervisual-studio-2019sqlclr

Visual Studio 2019 missing SQL Server


I have installed VS 2019 with only the "Data storage and processing" option in the Workloads selection. However, after creating a new "SQL Server Database Project" there is no "SQL Server" section under "Project | Add New Item | Installed". The VS2019 installation did install "SQL Server Data Tools" so I am at a loss as to why there is no SQL Server section in Add New Item.

Which workload do I need to install to have SQL Server show in "Project | Add New Item | Installed" in VS2019? I also have SQL Server 2019 installed.


Solution

  • Please try selecting following options under "Cloud, database, and server" from Individual Components tab while modifying the VS 2019 installation through Visual Studio Installer:

    1. Data sources for Sql server support
    2. SQL server data tools