sqlpackage fails to run on dotnet 8.0

[sloncho]

• SqlPackage Version: 162.1.167
• .NET Framework (Windows-only) or .NET Core: 8.0.0
• Environment (local platform and source/target platforms): linux

Steps to Reproduce:

1. Install dotnet tool - works well w/ dotnet 8.0:

/opt/hostedtoolcache/dotnet/dotnet tool update --global microsoft.sqlpackage
Skipping NuGet package signature verification.
You can invoke the tool using the following command: sqlpackage
Tool 'microsoft.sqlpackage' (version '162.1.167') was successfully installed.

2. Attempt to use it:

sqlpackage /Version:true
You must install or update .NET to run this application.

App: /home/vsts/.dotnet/tools/sqlpackage
Architecture: x64
Framework: 'Microsoft.NETCore.App', version '6.0.0' (x64)
.NET location: /opt/hostedtoolcache/dotnet

The following frameworks were found:
  8.0.0 at [/opt/hostedtoolcache/dotnet/shared/Microsoft.NETCore.App]

Learn more:
https://aka.ms/dotnet/app-launch-failed

To install missing framework, download:
https://aka.ms/dotnet-core-applaunch?framework=Microsoft.NETCore.App&framework_version=6.0.0&arch=x64&rid=linux-x64&os=ubuntu.22.04

Did this occur in prior versions? If not - which version(s) did it work in?

It works well w/ 6.0, we are trying to upgrade our tooling to run on 8.0.

[llali]

@sloncho a preview version of sqlpackage, which support .Net8, is now available. You can try it passing the specific version to dotnet tool command dotnet tool install --global Microsoft.SqlPackage --version 162.2.69-preview

[StefanOverHaevgRZ]

@llali Shouldn't there also be a new version of the Microsoft.Build.Sql package then?
Do you have any ETA when this will leave the preview phase and become GA?