microsoft/DacFx issues and pull requests

#362 - Composite Tables

Issue - State: open - Opened by airwedge1 8 months ago - 2 comments
Labels: enhancement

#361 - Table rebuilds when changing column type from VARCHAR(MAX)

Issue - State: open - Opened by asrichesson 8 months ago - 2 comments
Labels: bug

#360 - Improve performance of object reference resolution from dacpac-dependencies during build by optimizing dacpac internals

Issue - State: open - Opened by IVNSTN 8 months ago

#358 - `dotnet msbuild /t:restore` fails to restore a solution if it contains `dwproj` project

Issue - State: closed - Opened by IVNSTN 8 months ago - 1 comment
Labels: bug

#357 - Ignore QueryInsights schema for extraction from Fabric DW

Issue - State: open - Opened by salilkanade 8 months ago - 2 comments
Labels: bug, sqldw

#356 - Fix templates Nuget package

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

#355 - Add icon png and fix build warnings

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

#354 - Feature request: Add analogue of `nameof` expression from C# for better reference control to SSDT/DacFx

Issue - State: open - Opened by IVNSTN 9 months ago

#353 - Update DacFx to 162.1.167

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

#352 - Update Converting-Existing.md

Pull Request - State: closed - Opened by SeenaAugusty 9 months ago

#351 - Converting-Existing.md sample path is wrong

Issue - State: closed - Opened by tps-pcaldwell 9 months ago
Labels: bug

#350 - DacFx shows permanent diff on table constraints and/or computed columns if some specific expressions used

Issue - State: open - Opened by IVNSTN 9 months ago - 3 comments
Labels: bug, P1

#349 - Column Encryption: "Cannot drop column master key because column encryption key is encrypted by it."

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

#348 - Schema Compare failed: Unexpected exception ...: Unable to cast object of type 'System.Boolean' to type 'System.Int32'.

Issue - State: open - Opened by SakshiS-harma 9 months ago - 6 comments
Labels: bug, sqldw, sqlserverless

#346 - Could not resolve SDK "Microsoft.Build.Sql".

Issue - State: closed - Opened by j-dc 9 months ago - 5 comments
Labels: bug, area: build sdk

#345 - Deployment Extension Configuration Item Fails SqlBuild

Issue - State: open - Opened by znamenap 9 months ago
Labels: bug, area: build sdk

#344 - Set ReferenceAssemblies as implicitly defined

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

#343 - DacPackage.Unpack throws DacServiceException when trying to unpack dacpac with database reference

Issue - State: open - Opened by k0zi 10 months ago - 2 comments
Labels: bug

#342 - Help needed: How to define multiple DacpacName from a single PackageReference?

Issue - State: closed - Opened by IVNSTN 10 months ago - 4 comments
Labels: question, area: build sdk

#341 - SqlProj Build Fails When Deployment Contributor Is Required

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

#340 - Deploy with DropObjectsNotInSource option drops permission role even with DropRoleMembersNotInSource set to false

Issue - State: closed - Opened by llali 10 months ago
Labels: bug, fixed-pending-release

#339 - Deploy with db_owner and DropObjectsNotInSource option user drops the user in target

Issue - State: open - Opened by llali 10 months ago
Labels: enhancement

#338 - ENABLE_BROKER was disabled by publish dacpac

Issue - State: open - Opened by ch0mik 10 months ago - 1 comment
Labels: bug, documentation

#337 - SchemaComparisonResult fails every time.

Issue - State: closed - Opened by Aldebaran91 10 months ago - 4 comments
Labels: bug

#334 - Add pipeline to build SDK nightly and push to internal feed

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

#333 - Re Publish: Server`s EVENT NOTIFICATION dublicate error

Issue - State: open - Opened by Mnior 10 months ago
Labels: bug, backlog

#332 - Add code analyzers support as nuget-packages to new SDK

Issue - State: open - Opened by IVNSTN 10 months ago - 1 comment
Labels: enhancement, area: build sdk

#331 - Azure SQL Database deployment Task(Dacpac) issue

Issue - State: closed - Opened by DhatyaSri 10 months ago - 3 comments
Labels: bug, need-more-info

#330 - SQLProj Targets Wrong Framework Despite Explicit net6.0 Specification

Issue - State: closed - Opened by walidmabdelal 10 months ago - 2 comments
Labels: bug, area: build sdk

#329 - DacFx exposes local computer folder structure by embedding full paths to dacpac-dependencies into built dacpac

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

#328 - Schema Compare fails with "login failed for user <token-identified principal>"

Issue - State: closed - Opened by srahlf 11 months ago - 11 comments
Labels: bug

#327 - DacFx gives a false-positive constant warning on Synonym to User-defined datatype

Issue - State: closed - Opened by IVNSTN 10 months ago
Labels: bug, fixed-pending-release

#326 - DacFx gives false-positive constant warning if source service or a contract is a variable in BEGIN DIALOG CONVERSATION statement

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

#325 - Import fails if there were permissions associated with dropped ledger tables

Issue - State: closed - Opened by zijchen 10 months ago - 1 comment
Labels: bug, sql-feature

#324 - extracting empty database with extract target != dacpac or file results in incorrect success message

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

#323 - primary key succeeds in build, fails to publish

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

#322 - adds dwunified target platform

Pull Request - State: closed - Opened by dzsquared 10 months ago

#321 - README: Fix the Microsoft.Build.Sql NuGet link

Pull Request - State: closed - Opened by bjss-colin 11 months ago

#320 - Make it more x-plat

Pull Request - State: closed - Opened by ErikEJ 11 months ago

#319 - sql project template not working on arm

Issue - State: closed - Opened by gfody 11 months ago - 4 comments
Labels: bug, area: build sdk

#318 - Update typo/bad link on Functionality.md

Pull Request - State: closed - Opened by chris904apps 11 months ago - 1 comment

#316 - Microsoft.Build.Sql: does not work with NuGet centralized package management

Issue - State: closed - Opened by Aaronontheweb 11 months ago - 2 comments
Labels: bug, area: build sdk

#315 - Login failed for user '<token-identified principal>' DACPAC Publish with AccessToken authentication

Issue - State: closed - Opened by paulgartner1 11 months ago - 2 comments
Labels: bug

#314 - Update DacFx version to 162.1.124-preview

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

#313 - Import should show warning if the compat level is lower than the compat level in the bacpac

Issue - State: open - Opened by llali 11 months ago - 1 comment
Labels: enhancement

#312 - Added a section in readme for the telemetry feature

Pull Request - State: closed - Opened by llali 11 months ago - 1 comment

#311 - Visual Studio can not find the Microsoft.SqlServer.Dac.Extensions file/assembly

Issue - State: closed - Opened by Mattnificent 11 months ago - 11 comments
Labels: bug

#310 - Export completes even if it fails to serialize elements to model.xml

Issue - State: open - Opened by llali 11 months ago - 2 comments
Labels: bug, P1

#309 - Deployment fails when system versioning table needs update and there's a new schema

Issue - State: closed - Opened by llali 11 months ago
Labels: bug, fixed-pending-release

#308 - SqlPackage generates deploy script with invalid syntax when altering in-memory DB table if there is a schema-bound function dependent on it

Issue - State: closed - Opened by IVNSTN 11 months ago
Labels: bug, fixed-pending-release

#307 - SDK-style sqlproj is not integrated well with VS 2019 Solution Explorer

Issue - State: closed - Opened by IVNSTN 11 months ago - 3 comments
Labels: enhancement, area: build sdk, area: ssdt

#306 - /p:ScriptDeployStateCheck=True causes deploy script to ignore errors.

Issue - State: open - Opened by asrichesson 11 months ago
Labels: bug

#305 - "Value cannot be null. (Parameter 'AKV')" Script Action using azure key vault column encryption

Issue - State: closed - Opened by asrichesson 11 months ago - 6 comments
Labels: bug, fixed-pending-release, P1, area: encryption

#304 - Build error SQL71501: [...] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects

Issue - State: open - Opened by SoccerBoyMalloy 11 months ago
Labels: bug

#303 - Drop Certificate Login

Issue - State: open - Opened by TorstenStrauss 11 months ago
Labels: bug

#302 - Server level permissions are not allowed

Issue - State: open - Opened by TorstenStrauss 11 months ago
Labels: bug

#301 - CREATE CERTIFICATE FROM BINARY

Issue - State: open - Opened by TorstenStrauss 11 months ago - 1 comment
Labels: bug

#300 - Dacpac deployment of Synapse containing External tables runs very slow or does not complete

Issue - State: closed - Opened by RichardBorges-AlintaEnergy 12 months ago - 4 comments
Labels: bug, fixed-pending-release

#299 - Import fails when target has the collation set and importing data with ASCII values

Issue - State: open - Opened by ssreerama 12 months ago
Labels: enhancement, triaged

#298 - partitioned Table is always completely rebuild without reason

Issue - State: open - Opened by j-dc 12 months ago - 9 comments
Labels: bug, need-more-info, P1

#297 - SqlPackage doesn't honor impersonation from PowerShell

Issue - State: open - Opened by kkloss-od 12 months ago - 3 comments
Labels: bug, documentation

#296 - Error SQL0: Data cannot be imported into target because it contains one or more user objects

Issue - State: open - Opened by mikejwhat 12 months ago - 3 comments

#295 - Changing Primary Key Constraint Name Causes Table Rebuild

Issue - State: open - Opened by asrichesson about 1 year ago - 7 comments
Labels: bug

#294 - Error while calling DacServices.Register method from Powershell. Registering dac via powershell instead of via SSMS

Issue - State: closed - Opened by FCsean about 1 year ago - 5 comments
Labels: bug, under-investigation

#293 - AccessToken expiration

Issue - State: open - Opened by marty-buly about 1 year ago - 1 comment

#292 - Failed to import database - Collation 2052 is not supported

Issue - State: closed - Opened by scott-avery about 1 year ago
Labels: bug, fixed-pending-release, P1

#290 - Roadmap and future releases

Issue - State: open - Opened by teikitel about 1 year ago - 3 comments

#287 - Update README.md

Pull Request - State: closed - Opened by ErikEJ about 1 year ago

#286 - Order of packages in readme list seems odd

Issue - State: closed - Opened by ErikEJ about 1 year ago

#285 - Missing SQL Database options in dacpac for Microsoft Azure SQL Database target option in VS2022 17.5.5

Issue - State: closed - Opened by namangupta211 about 1 year ago - 2 comments
Labels: bug

#284 - Add test for SDK against .NET 8

Pull Request - State: closed - Opened by zijchen about 1 year ago

#283 - How to reference second model from another

Issue - State: open - Opened by simonsabin about 1 year ago - 4 comments
Labels: enhancement, area: build sdk

#282 - XML_COMPRESSION = ON causes a table rebuild on every deploy

Issue - State: closed - Opened by HamsterExAstris about 1 year ago - 3 comments
Labels: bug, under-investigation, need-more-info

#281 - DacPackage.UpdateModel() corrupts package, calling DacServices.GenerateDeployScript() fails afterwards.

Issue - State: closed - Opened by smichtch about 1 year ago - 5 comments
Labels: bug, fixed-pending-release

#280 - Default DatabaseVariableLiteralValue for master and msdb package references

Pull Request - State: closed - Opened by zijchen about 1 year ago

#279 - Create a master key error in Azure devops

Issue - State: closed - Opened by jthapa01 about 1 year ago - 3 comments
Labels: bug

#278 - SDK based project does not cover the transitive dependencies on the project reference

Issue - State: closed - Opened by jthapa01 about 1 year ago - 7 comments
Labels: enhancement, area: build sdk

#277 - TargetDatabaseSet property adds

Issue - State: open - Opened by jthapa01 about 1 year ago
Labels: bug, documentation, question, area: build sdk, area: ssdt

#275 - 0.1.10-preview of Microsoft.Build.Sql introduces build error on arm64 .NET 6

Issue - State: closed - Opened by dzsquared about 1 year ago - 3 comments
Labels: bug, fixed-pending-release, area: build sdk

#274 - update system dacpacs guidance

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

#273 - Package reference interferes with artifact reference in Microsoft.Build.Sql 0.1.9-preview

Issue - State: closed - Opened by lepagea01 about 1 year ago - 4 comments
Labels: bug, documentation, area: build sdk

#272 - sqlpackage Net. 6 doesn't throw the same "has an unresolved reference" error as sqlpacakge .Net 4.6.2

Issue - State: open - Opened by llali about 1 year ago
Labels: bug, under-investigation

#271 - sqlpackage Net. 6 doesn't throw the same "has an unresolved reference to object

Issue - State: open - Opened by llali about 1 year ago
Labels: bug

#270 - Schema compare between 2 databases with external tables doesn't work

Issue - State: closed - Opened by thomas-svrts about 1 year ago - 30 comments
Labels: bug, fixed-pending-release, sqldw

#269 - CREATE EXTERNAL FILE FORMAT not working with Synapse Serverless

Issue - State: closed - Opened by jds3d about 1 year ago - 8 comments
Labels: bug, fixed-pending-release, sqlserverless

#268 - Deprecate old system dacpac packages

Issue - State: closed - Opened by zijchen about 1 year ago - 6 comments

#267 - SQL71502 Error when using master SP

Issue - State: closed - Opened by gsimantiras about 1 year ago - 7 comments
Labels: need-more-info

#266 - Update SDK for separate master and msdb dacpacs

Pull Request - State: closed - Opened by zijchen about 1 year ago

#265 - [SQL DB Proj] Generated passwords for logins should indicate they're generated

Issue - State: open - Opened by Charles-Gagnon about 1 year ago
Labels: enhancement, backlog

#264 - Clustered columnstore index results in clustered index being created first

Issue - State: open - Opened by simonsabin about 1 year ago - 4 comments
Labels: bug, backlog, P1

#263 - Update DacFx package to 162.0.52

Pull Request - State: closed - Opened by zijchen about 1 year ago

#262 - Synapse Serverless not supported with .sqlproj

Issue - State: closed - Opened by jds3d about 1 year ago - 4 comments
Labels: bug, fixed-pending-release

#261 - SqlPackage throws an exception when run through Process() and both error and output are redirected

Issue - State: closed - Opened by argentini about 1 year ago - 1 comment
Labels: bug, fixed-pending-release

#260 - Bug: Import fails with error message 'Supplied parameter sid should be binary(16).' when the database has an AAD user associated with an AAD server login

Issue - State: closed - Opened by namangupta211 about 1 year ago
Labels: bug, fixed-pending-release, triaged

#253 - [Synapse Serverless] SqlPackage Extract is not adding the database scoped credential secret to the generated deployment script

Issue - State: open - Opened by ruippcunha about 1 year ago - 2 comments
Labels: bug, sqlserverless

GitHub / microsoft/DacFx issues and pull requests