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

[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

[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

[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]

story continues: Today trying to schema compare a Azure SQL DB with Fabric SQL DB. Upgraded to lastes VS2022 V17.14.7 and SQL Server Data Tools 14.14.26.0 just to get error:

The source and target platform must be the same to use Schema Compare for Fabric mirrored SQL database (preview)

tried also exporting the azure sql db first as dacpac and then running the dacpac as soure, but same result. How stupid is that , i just want to compare table / views which can be read from INFORMATION_SCHEMA accross microsoft platform consistently. Will now check if redgate SQL compare is more developer friendly

Update:
Ok, same troublte with Redgate comparing an AzureSQLDB with FabricSQLDB 😞

Could be so simple but now my next try/workaround will be to SQL Export the hole schema of both dbs in hope to identify different tables ...