Bob Duffy on 17 Nov 2023 10:08:06
Current Visual Studio supports All editions of SQL except Fabric.
This is an essential tool quick ad hoc schema compares.
Please consider adding support to SSDT for Fabric artefacts so that we can use SSDT.
https://learn.microsoft.com/en-us/sql/ssdt/how-to-use-schema-compare-to-compare-different-database-definitions?view=sql-server-ver16
Salil Kanade (administrator)
We've recently released SQL database projects support for Fabric Warehouse in Azure Data Studio and Visual Studio Code - which also includes support for schema compare. Would love to understand whether this satisfies your requirements or if you're specifically looking support in SSDT?
https://blog.fabric.microsoft.com/en-us/blog/sql-projects-support-for-warehouse-in-microsoft-fabric
- Comments (2)
RE: Add support for SSDT Schema Compare for DW and LH
With SQLpackage we can't do CI/CD when change the table structure ##[error]*** An error occurred during deployment plan generation. Deployment cannot continue.##[error]Error SQL0: Deployment cannot continue because table changes that require 'ALTER TABLE' are not supported on Synapse Data Warehouse in Microsoft Fabric at this time.##[error]System.Management.Automation.RemoteException##[error]The Azure SQL DACPAC task failed. SqlPackage.exe exited with code 1.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
RE: Add support for SSDT Schema Compare for DW and LH
We've recently released SQL database projects support for Fabric Warehouse in Azure Data Studio and Visual Studio Code - which also includes support for schema compare. Would love to understand whether this satisfies your requirements or if you're specifically looking support in SSDT? SQL Projects support for Warehouse in Microsoft Fabric | Microsoft Fabric Blog | Microsoft Fabric