search

microsoft / DacFx

SQL Server database schema validation, deployment, and upgrade runtime. Enables declarative database development and database portability across SQL Server versions and environments.
https://aka.ms/sqlpackage-ref
MIT License
292 stars 15 forks source link

Adding existing project causes VS 2022 to hang #425

Closed jphellemons closed 3 months ago

jphellemons commented 3 months ago

Steps to Reproduce:

  1. dotnet new -i Microsoft.Build.Sql.Templates
  2. dotnet new sqlproj -n ProductsTutorial
  3. create table (optional)
  4. Open VS 2022 Version 17.9.2
  5. Right click in solution
  6. Add existing project
  7. select sqlproj
  8. hang/wait

Did this occur in prior versions? If not - which version(s) did it work in? idk, first time I am using the new sdk database project

dzsquared commented 3 months ago

closing this as we have several items tracking the work for SSDT to support Microsoft.Build.Sql projects.

https://github.com/microsoft/DacFx/issues/180#issuecomment-1332850284

RyanThomas73 commented 3 months ago

@jphellemons I encountered the problem you described and the following allowed me to work around it:

After your step 2 and before opening visual studio, perform a dotnet restore on the new .sqlproj from the command line.