HowTo SQL Schema Compare ?

[jochenj]

i need to compare on object level (Table/Procedure..) schemas between Fabric Databases / Warehouses.  But i cannot find any tool working for this job:
- Visual Studio 2022 + SSDT 
   Seems not possible. I can add the connections but when try to compare i get "Error master.dbo.sysconfigure is not supported in this version of sql server".  Same error i get when i successfully "import" the fabric database as a "DB Project" but then try to compare livedb<>project

- Visual Studio Code
   Cannot find any extension to do the job. "DB Projects" contains no schema compare and "SQL Server" also not

- Azure Data Studio

Didn't try , dont want to install extra for this job inbecause its official deprecated

Anyone with insights for a working solution? Having "Fabric Deployment Pipelines" looks nice, but there i also only see the DB Artecfacts and not the DB Objects itself like tables.. to compare

[yoleic]

Hi @jochenj 

Good news - Schema Compare is also coming to VS Code mssql extension soon (Public Preview end of April) roadmap · microsoft/vscode-mssql Wiki.

If you'd like to see Schema Compare integrated natively inside the Fabric query editor, I suggest submitting an idea. Fabric Ideas - Microsoft Fabric Community.

Thanks!

[jochenj · Accepted solution]

hurray, it works now with Visual Studio. Had to update to latest VS version.
--> SQL database in Microsoft Fabric (requires VS2022 17.12)
Reference: Install SQL Server Data Tools (SSDT) - SQL Server Data Tools (SSDT) | Microsoft Learn

[Anonymous]

Hi @jochenj 

Maybe you can try to use Redgate SQL Compare or xSQL Schema Compare.

SQL Compare: Compare And Synchronize SQL Server Schemas
Compare and synchronize the schema of on-premise SQL Server or Azure Databases - xSQL Software

Best Regards,

Jayleny