Add support for SSDT Schema Compare for DW and LH

[BOB10]

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

[salilkanade1]

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

[jesus_solasoler]

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-

[salilkanade1]

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
 

[jochenj]

SQL database projects for Visual Studio Code do NOT contain any schema compare functionality that I can find?! It's really strange that it includes a 'publish' feature but lacks schema compare like in Visual Studio; this feels half-baked. But VS2022 for me throws also error if i try to schema compare fabric databases. Data Studio is deprecated, so also no real option..