microsoft/DacFx issues and pull requests

#462 - Lacking Documentation for PackageOptions.IgnoreValidationErrors property

Issue - State: open - Opened by andrew-sumner about 9 hours ago

#461 - The latest version has DeploymentPlanModifier that includes methods becoming static, which affects any developments that are done utilising this class.

Issue - State: closed - Opened by yelochka 12 days ago - 4 comments
Labels: regression

#460 - Plans to update sql unit tests?

Issue - State: open - Opened by nholland20 17 days ago - 1 comment
Labels: question

#459 - Azure Pipelines fail while MSBuild@1 The reference assemblies for .NETFramework,Version=v4.0 were not found. To resolve this, install the Developer

Issue - State: closed - Opened by panos23kar 18 days ago - 8 comments
Labels: bug

#458 - partitioned Tables of BIT datatype are rebuilding without reason

Issue - State: open - Opened by ssreerama 19 days ago
Labels: bug, fixed-pending-release

#457 - docs and templates option add for 162.3

Pull Request - State: open - Opened by dzsquared 20 days ago

#456 - Incorrect deployment plan order generated when a table valued function with schema binding is dependent on Temporal table

Issue - State: open - Opened by sejagada 24 days ago
Labels: bug, area: encryption

#455 - Update DacFx to 162.3.563

Pull Request - State: closed - Opened by zijchen 25 days ago

#454 - adding some docs links

Pull Request - State: closed - Opened by dzsquared about 1 month ago

#453 - Changing the length of an VARCHAR or NVARCHAR column that has explicit COLLATE defined that matches the database default COLLATION will trigger a data loss check in the script output

Issue - State: open - Opened by csommerolo about 1 month ago
Labels: bug

#452 - Making change to one external table results in all external tables getting dropped and recreated when Published to existing database

Issue - State: open - Opened by NathanMSFT about 1 month ago
Labels: bug, under-investigation, P1

#451 - Add more support to unsupported SqlPermissions

Issue - State: open - Opened by ssreerama about 1 month ago
Labels: bug

#450 - $(TargetPath) should be the output .dacpac file

Issue - State: open - Opened by benjamin-hodgson about 1 month ago
Labels: area: build sdk

#449 - UpdateSpecification.AcceptChildren issue results in out of sequence explicit visit calls

Issue - State: open - Opened by kenlnetherland about 1 month ago
Labels: bug

#448 - Incremental building

Issue - State: open - Opened by benjamin-hodgson about 1 month ago - 2 comments
Labels: enhancement, area: build sdk

#447 - Support dotnet publish

Issue - State: open - Opened by benjamin-hodgson about 1 month ago
Labels: enhancement, area: build sdk

#446 - Support UseArtifactsOutput in .NET 8

Issue - State: open - Opened by benjamin-hodgson about 1 month ago
Labels: enhancement, area: build sdk

#445 - Unresolved reference error creating synonym on table and type with same name

Issue - State: open - Opened by zijchen about 2 months ago
Labels: bug, area: model resolver

#444 - Remove tests for .NET SDK 3.1 and 5, add tests for .NET 9

Pull Request - State: closed - Opened by zijchen about 2 months ago

#443 - Updating Microsoft.Build.Sql for utilising in Visual Studio

Pull Request - State: closed - Opened by Ri7Sh about 2 months ago - 2 comments

#442 - Delete ADO builds folder

Pull Request - State: closed - Opened by zijchen about 2 months ago

#440 - Incorrect deployment plan order generated when a Temporal table with foreign key constraint is encrypted

Issue - State: closed - Opened by abhikum 2 months ago - 1 comment
Labels: bug, fixed-pending-release, area: encryption

#439 - SqlSchemaCompare target uses property names that are reserved

Issue - State: open - Opened by maciejw 2 months ago
Labels: bug

#438 - SSMS hits out of memory errors during bacpac export where nvarchar(max) column has extremely long string

Issue - State: open - Opened by dzsquared 3 months ago
Labels: bug

#437 - Visual Studio SQL Schema Compare - Targeting Split/Composite SQL Server Database Projects

Issue - State: open - Opened by emdempster 3 months ago
Labels: enhancement, area: schema compare

#436 - DacFX does not generate the OBJECT_ID property for CREATE USER

Issue - State: open - Opened by JensKSuessmeyer 3 months ago
Labels: bug

#434 - Data Tools doesn't accept FORCESEEK parameter in CHANGETABLE function

Issue - State: open - Opened by dzsquared 3 months ago
Labels: bug

#433 - Schema differences for scalar-valued function

Issue - State: open - Opened by hgsenger 3 months ago
Labels: bug

#433 - Schema differences for scalar-valued function

Issue - State: open - Opened by hgsenger 3 months ago
Labels: bug

#432 - Permanent Difference in Custom Table Type Computed Column

Issue - State: open - Opened by asrichesson 3 months ago
Labels: bug, persistent-schema-differences

#431 - computed columns in external tables

Issue - State: open - Opened by dzsquared 3 months ago
Labels: enhancement

#430 - error MSB4020: The value "" of the "Project" attribute in element <Import> is invalid with version 0.1.15-preview

Issue - State: open - Opened by yorek 3 months ago - 11 comments
Labels: bug, area: build sdk

#430 - error MSB4020: The value "" of the "Project" attribute in element <Import> is invalid with version 0.1.15-preview

Issue - State: open - Opened by yorek 3 months ago - 10 comments
Labels: bug, area: build sdk

#428 - *** The SourceFile argument must refer to a file with a '.bacpac' extension.

Issue - State: closed - Opened by jackliusr 4 months ago - 4 comments

#427 - Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: The Element or Annotation class SqlIndex does not contain the Property class Online

Issue - State: closed - Opened by jackliusr 4 months ago - 56 comments

#427 - Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: The Element or Annotation class SqlIndex does not contain the Property class Online

Issue - State: open - Opened by jackliusr 4 months ago - 45 comments

#426 - SqlPackage - option to skip Windows logins

Issue - State: open - Opened by yarong-lifemap 4 months ago - 8 comments
Labels: enhancement

#425 - Adding existing project causes VS 2022 to hang

Issue - State: closed - Opened by jphellemons 4 months ago - 2 comments
Labels: bug

#425 - Adding existing project causes VS 2022 to hang

Issue - State: closed - Opened by jphellemons 4 months ago - 2 comments
Labels: bug

#424 - An overload of GenerateDeployScript that accepts Stream

Issue - State: open - Opened by rmeshksar 4 months ago
Labels: enhancement

#423 - Serverless Pool: Msg 15872, Level 16, State 1, Line 13 NOT NULL is not allowed for external table columns.

Issue - State: open - Opened by jasonhorner 4 months ago - 1 comment
Labels: bug, sqldw, sqlserverless

#422 - SqlPackage universal authentication to Azure SQL fails with error "You can't sign in here with a personal account. Use your work or school account instead"

Issue - State: open - Opened by GennadyGS 4 months ago - 2 comments
Labels: bug

#420 - Error MSB4018: System.NullReferenceException for an OpenJson operation

Issue - State: open - Opened by madjar4-cssmb 4 months ago - 1 comment
Labels: bug

#420 - Error MSB4018: System.NullReferenceException for an OpenJson operation

Issue - State: closed - Opened by madjar4-cssmb 4 months ago - 2 comments
Labels: bug, fixed-pending-release

#419 - SSDT error SQL71526 on stored procedure.

Issue - State: open - Opened by hacitandogan 4 months ago - 2 comments
Labels: bug

#419 - SSDT error SQL71526 on stored procedure.

Issue - State: open - Opened by hacitandogan 4 months ago - 2 comments
Labels: bug

#418 - Move configuration dependent properties to sdk.targets

Pull Request - State: closed - Opened by zijchen 4 months ago

#417 - SqlPackage Publish fails in some conditions with "ISqlModelElement: Identifier part cannot be null"

Issue - State: open - Opened by IVNSTN 4 months ago - 6 comments
Labels: bug

#416 - When SqlPackage fails with SQL72014 because of drop attempt blocked by SCHEMABINDING it should print object schema name

Issue - State: closed - Opened by IVNSTN 4 months ago - 5 comments
Labels: bug

#416 - When SqlPackage fails with SQL72014 because of drop attempt blocked by SCHEMABINDING it should print object schema name

Issue - State: open - Opened by IVNSTN 4 months ago
Labels: bug, good first issue

#415 - Build ouput seems to be badly formed, causing unexpected formatting of error list

Issue - State: closed - Opened by ErikEJ 4 months ago - 9 comments
Labels: bug, fixed-pending-release, area: ssdt

#414 - Update DacFx version to 162.2.111

Pull Request - State: closed - Opened by zijchen 4 months ago

#414 - Update DacFx version to 162.2.111

Pull Request - State: closed - Opened by zijchen 4 months ago

#413 - Incorrect deployment plan order generated when there is circular reference between column dropped and column referenced by function

Issue - State: open - Opened by abhikum 4 months ago
Labels: bug

#412 - Unresolved reference to object in SQL project results in build warning instead of error

Issue - State: open - Opened by dzsquared 4 months ago
Labels: bug

#411 - ScriptDom interprets ambiguously the next word right after transaction control statement

Issue - State: open - Opened by IVNSTN 5 months ago
Labels: bug

#410 - Bump NuGet.Packaging from 6.3.1 to 6.3.4 in /test/Microsoft.Build.Sql.Tests

Pull Request - State: closed - Opened by dependabot[bot] 5 months ago
Labels: dependencies

#409 - Invalid value for the "SqlTarget" parameter of the "SqlBuildTask" task.

Issue - State: closed - Opened by greg84 5 months ago - 3 comments
Labels: bug

#408 - Building a project under a folder with escaped spaces skips scripts

Issue - State: open - Opened by Charles-Gagnon 5 months ago
Labels: bug, area: build sdk, P1

#407 - Remove DacFx bits from SDK package, use package reference instead

Pull Request - State: open - Opened by zijchen 5 months ago - 1 comment

#406 - Build Error on CTAS Statements

Issue - State: open - Opened by joearusinfo 9 months ago - 15 comments
Labels: bug, P1

#405 - Issues referencing sys.sysprocesses

Issue - State: open - Opened by KaineVarley about 5 years ago - 2 comments
Labels: bug

#404 - Open internal utils for matching ColumnReferenceExpression to object in SchemaModel

Issue - State: open - Opened by seekingtheoptimal over 4 years ago
Labels: enhancement

#403 - When using DoNotDropObjectTypes argument, sqlpackage ignores DropIndexesNotInSource=false

Issue - State: open - Opened by GingerSnap-xx about 4 years ago - 2 comments
Labels: bug

#402 - Extensions discovery issue in DacPac's DacServices.Deploy()

Issue - State: open - Opened by Pikhulya almost 4 years ago - 1 comment
Labels: bug

#401 - The dependency of DacPacs DacServices.Deploy() on Assembly.Location is erroneous when DLLs are embedded into EXE

Issue - State: open - Opened by LDan1117 over 3 years ago
Labels: bug

#400 - How get the default value if the specific field

Issue - State: open - Opened by LmG7119 over 3 years ago - 3 comments

#399 - DacFx - only return public types as properties

Issue - State: open - Opened by GoEddie about 5 years ago
Labels: enhancement

#398 - Cannot deploy dacpac with Graph Table that has edges

Issue - State: open - Opened by npbenjohnson over 3 years ago
Labels: bug, sql-feature

#397 - IncludeFileNamesCollector doesn't work cross-platform

Issue - State: open - Opened by jmezach about 4 years ago
Labels: enhancement, area: build sdk

#396 - Get a list of DacFx operations?

Issue - State: open - Opened by GoEddie about 5 years ago
Labels: documentation

#395 - sqlpackage.exe /a:script (and its equivalents) needs to have a consistent ordering to the output

Issue - State: open - Opened by StingyJack about 6 years ago
Labels: enhancement

#394 - Late initialization of ModelTypeClasses (at least) such as PrimaryKeyConstraint.TypeClass??

Issue - State: open - Opened by JasonKleban over 7 years ago - 1 comment
Labels: bug

#393 - NuGet package for strongly typed DacFx

Issue - State: open - Opened by MihailRomanov about 9 years ago - 15 comments
Labels: enhancement

#392 - Not actionable extension related errors in DacServices.Deploy()

Issue - State: open - Opened by Pikhulya almost 4 years ago
Labels: enhancement

#391 - Change default target framework to netstandard2.1

Pull Request - State: closed - Opened by zijchen 5 months ago - 2 comments

#390 - Build error SQL71636: You cannot use types or statements that modify the database state.

Issue - State: open - Opened by jasonhorner 5 months ago - 2 comments
Labels: bug, sqldw

#389 - DacFx does not indicate existing problem in query if # or @ involved in statement

Issue - State: open - Opened by IVNSTN 5 months ago - 2 comments
Labels: bug

#387 - Always Encrypted: Incorrect drop & create deployment step order when computed column is dropped as a part column encryption

Issue - State: open - Opened by abhikum 5 months ago
Labels: bug, area: encryption

#386 - Dacfx fails to publish the dacpac while creating the non-clustered index when table has disabled clustered index

Issue - State: closed - Opened by ssreerama 5 months ago
Labels: bug, fixed-pending-release

#385 - DacFx shows permanent diff on some permissions if there was a grantor specified in the project sources

Issue - State: open - Opened by IVNSTN 5 months ago
Labels: bug

#384 - DacFx generates invalid publish script with wrong CREATE command order if temporal table and dacpac-dependency involved

Issue - State: open - Opened by IVNSTN 5 months ago - 1 comment
Labels: bug

#383 - DacPac file is searched in upper case form during the deployment. Could break deployment in some environments like Turkish.

Issue - State: open - Opened by tomas-xyz 5 months ago
Labels: bug

#370 - SqlPackage Extract for Synapse Dedicated SQL Pool - throws error SQL73068: Unsupported collation 'Latin1_General_100_CI_AS_SC_UTF8'

Issue - State: open - Opened by michalExt 7 months ago
Labels: bug, sqldw

#368 - sqlproj: Add compiler error for mismatched number of select and insert columns

Issue - State: open - Opened by asrichesson 7 months ago
Labels: enhancement

#367 - Azure Data Studio how to rename column for dacpac so it is actually renamed when applying db changes

Issue - State: open - Opened by AdamMachera 7 months ago
Labels: enhancement

#366 - Serverless Pool View created on OPENROWSET with csv file source reports errors when the option: HEADER_ROW = TRUE is specified

Issue - State: open - Opened by jasonhorner 7 months ago
Labels: bug

#365 - Synapse Serverless Pool View defined using SELECT * on OPENROWSET query with columns defined causes SQL71501 Error

Issue - State: open - Opened by jasonhorner 7 months ago - 4 comments
Labels: bug, sqlserverless

#364 - Custom Static Analysis Rules with DacFx 150 Not Executed on Build from VS 2022 Command Line

Issue - State: closed - Opened by chlafreniere 7 months ago - 6 comments
Labels: bug, fixed-pending-release

#363 - SqlPackage Exports (bacpacs) are not importable by SSMS or Azure import/export

Issue - State: open - Opened by bryanhunwardsen 8 months ago - 5 comments
Labels: bug, P1

GitHub / microsoft/DacFx issues and pull requests