Forum Discussion

MikeSmith-edu-tech's avatar
MikeSmith-edu-tech
Copper Contributor
Dec 18, 2024

Azure Data Studio - SQL DB Project build error MSB4020

Hi folks. I'm just getting started with ADS as we need to move an existing on-prem DB to Azure. I 'm trying to use ADS to set up the target DB. I installed the SQL Database Projects extension and created a project from our on-prem DB, but every time I try to build it I get Error MSB4020:

stdout: C:\Program Files\dotnet\sdk\7.0.403\Sdks\Microsoft.NET.Sdk\targets\Microsoft.NET.Sdk.targets(1199,3): error MSB4020: The value "" of the "Project" attribute in element <Import> is invalid. [c:\testing\WT pre-migration\WT pre-migration.sqlproj]

Here's the proj file:

<?xml version="1.0" encoding="utf-8"?>

<Project DefaultTargets="Build">

  <Sdk Name="Microsoft.Build.Sql" Version="0.2.0-preview" />

  <PropertyGroup>

    <Name>WT pre-migration</Name>

    <ProjectGuid>{AE8E25C1-F1D6-4447-A008-2C24C82B51FA}</ProjectGuid>

    <DSP>Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider</DSP>

    <ModelCollation>1033, CI</ModelCollation>

  </PropertyGroup>

  <Target Name="BeforeBuild">

    <Delete Files="$(BaseIntermediateOutputPath)\project.assets.json" />

  </Target>

</Project>

No RepliesBe the first to reply

Resources