How can we use SQL DataBase project in Visual Studio code?

[prashantkumarll]

For using Database projects with SQL Server we need to run the below commands:

List the available dotnet sdks:

dotnet --list-sdks

Install SQL SDK:

 dotnet new install microsoft.build.sql.templates

Install SQLPackage:

dotnet tool install -g microsoft.sqlpackage

echo 'export PATH="$PATH:$HOME/.dotnet/tools"' >> ~/.zshrc\n
​source ~/.zshrc
​sqlpackage /version