microsoft/DacFx issues and pull requests

#499 - Import Database - External file format missing some FORMAT_OPTIONS - Synapse Serverless Pool

Issue - State: open - Opened by anooppaul-official 4 days ago
Labels: bug

#498 - Unexpected failure when publishing using SqlPackage: Object reference not set to an instance of an object

Issue - State: open - Opened by rpmrmartin 6 days ago
Labels: bug

#497 - Add target to remove included files via :r from build

Pull Request - State: open - Opened by zijchen 8 days ago

#496 - Update Microsoft.Build.Sql.nuspec

Pull Request - State: open - Opened by ErikEJ 10 days ago

#495 - Rules not being picked up by 0.2.3

Issue - State: closed - Opened by ErikEJ 12 days ago - 8 comments
Labels: bug, area: build sdk

#494 - Handling SDK updates

Issue - State: open - Opened by ErikEJ 12 days ago - 1 comment
Labels: enhancement, area: build sdk

#493 - DacFx doesn't get schema permission differences in comparison.

Issue - State: open - Opened by Aldebaran91 13 days ago - 1 comment
Labels: bug

#492 - Update DacFx version to 162.4.92

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

#491 - Dacpac file name does not match `<Name />` tag

Issue - State: open - Opened by robertmclaws 17 days ago - 2 comments
Labels: bug, area: build sdk

#490 - Update Project Template

Pull Request - State: open - Opened by robertmclaws 17 days ago

#489 - better handling of deployments to database with large volumes of stored procedures

Issue - State: open - Opened by maciejw 24 days ago
Labels: enhancement, performance

#488 - Add support for CREATE INDEX WITH DROP_EXISTING = ON

Issue - State: open - Opened by maciejw 24 days ago

#487 - Add support for dotnet publish

Pull Request - State: closed - Opened by zijchen 26 days ago - 5 comments

#486 - Missing references in SQLpackage contributor extension (DeploymentPlanModifier)

Issue - State: open - Opened by BarrydeBoerUMCG 28 days ago - 3 comments
Labels: bug

#485 - SqlPublish fails when run from dotnet

Issue - State: open - Opened by derkyjadex about 1 month ago - 4 comments
Labels: area: build sdk

#484 - Database Master Key not included as part of dacpac created using Extract functionality in SqlPackage

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

#484 - Database Master Key not included as part of dacpac created using Extract functionality in SqlPackage

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

#483 - Add support for ALTER COLUMN WITH (ONLINE=ON)

Issue - State: open - Opened by HamsterExAstris about 2 months ago

#483 - Add support for ALTER COLUMN WITH (ONLINE=ON)

Issue - State: open - Opened by HamsterExAstris about 2 months ago
Labels: enhancement

#482 - Add Pre-compare Script Option for DACPAC Publishing

Issue - State: open - Opened by dzsquared about 2 months ago - 1 comment

#482 - Add Pre-compare Script Option for DACPAC Publishing

Issue - State: open - Opened by dzsquared about 2 months ago - 1 comment

#481 - strange build warning output with guid value

Issue - State: open - Opened by dzsquared about 2 months ago
Labels: bug, area: build sdk

#480 - QueryStore option is set to 100MB after every deployment

Issue - State: open - Opened by ssreerama about 2 months ago - 2 comments
Labels: bug

#479 - Add SQL code analysis from PackageReference or ProjectReference

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

#478 - Central feed fixes for tests

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

#477 - Azure SQL - JSON Data Type

Issue - State: closed - Opened by rac146 2 months ago - 6 comments
Labels: sql-feature

#476 - Non-default dynamic data masking operations not supported for date

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

#475 - Bacpac file won't restore due to columnstore indexes on columns with specific data types.

Issue - State: open - Opened by dzsquared 2 months ago - 1 comment
Labels: bug, P1

#474 - Schema compare issue with sensitivity classifications

Issue - State: closed - Opened by zijchen 2 months ago
Labels: bug, fixed-pending-release, area: schema compare

#473 - Binskim errors in SqlServerSpatial160.dll

Issue - State: closed - Opened by dhavv 2 months ago - 1 comment

#472 - [dev] Use fluent assertions

Issue - State: open - Opened by zijchen 2 months ago

#471 - Incorrect Deployment Order when removing Column Encryption Key

Issue - State: open - Opened by asrichesson 2 months ago - 2 comments
Labels: bug, area: encryption

#470 - Remove local testing source from nuget.config

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

#469 - Observed multiple vulnerabilities in sqlpackage utility.

Issue - State: open - Opened by mayurlokare24 2 months ago - 3 comments
Labels: bug

#468 - .

Issue - State: closed - Opened by ehpmfigueroa 2 months ago
Labels: bug

#467 - SqlPackage produces huge deployment script and diff report for inmemory procs and functions

Issue - State: closed - Opened by IVNSTN 2 months ago - 5 comments

#466 - Unclarity on system .dacpacs

Issue - State: open - Opened by ErikEJ 3 months ago - 3 comments
Labels: documentation

#466 - Unclarity on system .dacpacs

Issue - State: closed - Opened by ErikEJ 3 months ago - 4 comments
Labels: documentation

#465 - Update DacFx to 162.3.566

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

#464 - Visual Studio throws critical error when UDT type has index

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

#463 - Adding VS targets path and Excluding BuildExtensionConfiguration and DeployExtensionConfiguration from Build

Pull Request - State: closed - Opened by Ri7Sh 3 months ago

#462 - Lacking Documentation for PackageOptions.IgnoreValidationErrors property

Issue - State: open - Opened by andrew-sumner 3 months ago - 3 comments
Labels: documentation

#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 4 months ago - 4 comments
Labels: regression

#460 - Plans to update sql unit tests?

Issue - State: open - Opened by nholland20 4 months 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 4 months ago - 8 comments
Labels: bug

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

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

#457 - docs and templates option add for 162.3

Pull Request - State: closed - Opened by dzsquared 4 months 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 4 months ago
Labels: bug, area: encryption

#455 - Update DacFx to 162.3.563

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

#454 - adding some docs links

Pull Request - State: closed - Opened by dzsquared 4 months 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 4 months 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: closed - Opened by NathanMSFT 4 months ago
Labels: bug, under-investigation, fixed-pending-release, P1

#451 - Add more support to unsupported SqlPermissions

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

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

Issue - State: open - Opened by benjamin-hodgson 5 months ago
Labels: area: build sdk

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

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

#448 - Incremental building

Issue - State: open - Opened by benjamin-hodgson 5 months ago - 2 comments
Labels: enhancement, area: build sdk

#447 - Support dotnet publish

Issue - State: closed - Opened by benjamin-hodgson 5 months ago - 6 comments
Labels: enhancement, area: build sdk

#446 - Support UseArtifactsOutput in .NET 8

Issue - State: open - Opened by benjamin-hodgson 5 months 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 5 months ago - 1 comment
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 5 months ago

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

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

#442 - Delete ADO builds folder

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

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

Issue - State: closed - Opened by abhikum 5 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 5 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 6 months ago
Labels: bug

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

Issue - State: open - Opened by emdempster 6 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 6 months ago
Labels: bug

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

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

#433 - Schema differences for scalar-valued function

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

#433 - Schema differences for scalar-valued function

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

#432 - Permanent Difference in Custom Table Type Computed Column

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

#431 - computed columns in external tables

Issue - State: open - Opened by dzsquared 7 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 7 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 7 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 7 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: open - Opened by jackliusr 7 months ago - 45 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 7 months ago - 56 comments

#426 - SqlPackage - option to skip Windows logins

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

#425 - Adding existing project causes VS 2022 to hang

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

#425 - Adding existing project causes VS 2022 to hang

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

#424 - An overload of GenerateDeployScript that accepts Stream

Issue - State: open - Opened by rmeshksar 7 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 7 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 7 months ago - 2 comments
Labels: bug

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

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

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

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

#419 - SSDT error SQL71526 on stored procedure.

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

#419 - SSDT error SQL71526 on stored procedure.

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

#418 - Move configuration dependent properties to sdk.targets

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

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

Issue - State: open - Opened by IVNSTN 7 months ago - 11 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 7 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 7 months ago
Labels: bug, good first issue

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

Issue - State: closed - Opened by abhikum 7 months ago - 1 comment
Labels: bug

GitHub / microsoft/DacFx issues and pull requests