title: Is it literally impossible to build a SQL Server database project in Azure Data Studio on an M1 Mac?
body: <p>I'm attempting to set myself up with Azure Data Studio on my new M1 Mac Mini, but the SQL Server database project I'm working on refuses to build. This is the (completely useless) error I'm getting:</p>
  <pre><code>stdout: /Users/dumasded/.azuredatastudio/extensions/microsoft.sql-database-projects-0.13.0/BuildDirectory/Microsoft.Data.Tools.Schema.SqlTasks.targets(586,5): error MSB4181: The &quot;SqlBuildTask&quot; task returned false but did not log an error. [/Users/dumasded/Projects/db-project/DBProject.sqlproj]
  stdout:     0 Warning(s)
  stdout:     1 Error(s)
  </code></pre>
  <p>I can neither find nor remember where I got this idea but I somehow got it into my head that this has something to do with the version of the SDK I'm using - I'm currently using 6.0.100, which as far as I can tell is the only one that's arm64 compatible. Every attempt I've made to download, install and run an earlier version of the SDK on this machine has failed. If that is in fact the problem, I can't even get far enough to find out.</p>
  <p>Just to be sure it wasn't something to do with the existing project I was trying to set up, I created a brand new one from scratch and attempted to build that. It failed with the same error. It definitely appears to be a system issue and not a project-specific one.</p>
  <p>Is there any hope for me? Am I doomed to return to working on my crummy Lenovo Thinkpad? My breath is bated. Thanks in advance.</p>
  <p><strong>EDIT</strong></p>
  <p>I've just come across the ingenious <a href="https://github.com/rr-wfm/MSBuild.Sdk.SqlProj" rel="nofollow noreferrer">MSBuild.Sdk.SqlProj</a> as a potential solution to my issue, however my attempts to use it are still running up against SDK version issues:</p>
  <pre><code>error : The current SDK bundles target framework 'netcoreapp6.0' which is not supported by MSBuild.Sdk.SqlProj. Either install a .NET Core SDK that supports 2.1, 3.1 or 5.0, or file an issue at https://github.com/rr-wfm/MSBuild.Sdk.SqlProj/ to add support.
  </code></pre>
  <p>This would seem to confirm my initial suspicion that this is an issue of SDK versions.</p>
  <p><strong>EDIT 2</strong></p>
  <p>Neglected to mention that I'm using Azure Data Studio with the SQL Database Projects extension, which purports to handle the DACPAC creation seamlessly and across platforms. Though that hasn't been my experience thus far.</p>