topic Re: Which Target Platform in VS2022 for MS Fabric DWH project? in Data Warehouse

Which Target Platform in VS2022 for MS Fabric DWH project?

MaciejUrbaniak — Wed, 11 Jun 2025 13:58:06 GMT

In Visual Studio, which project type and target database should I chose for MS Fabric DWH project? I use standard SQL database project template but no matter which Target Platform I chose, I get the same error message:

The source and target platform must be the same to use Schema Compare for Synapse Data Warehouse in Microsoft Fabric

My VS2022 version is 17.13.5.

Thanks,

Maciej

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

NandanHegde — Wed, 11 Jun 2025 15:22:30 GMT

Below blog should help :

https://blog.fabric.microsoft.com/en-us/blog/sql-projects-support-for-warehouse-in-microsoft-fabric/

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

MaciejUrbaniak — Wed, 11 Jun 2025 15:49:22 GMT

Thanks but the blog is about Visual Studio Code, Not Visual Studio Professional 2022.

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

v-veshwara-msft — Thu, 12 Jun 2025 06:27:03 GMT

Hi MaciejUrbaniak ,

Thanks for posting in Microsoft Fabric Community.

You can now set the target platform in Visual Studio to “Synapse Data Warehouse in Microsoft Fabric”, which uses the DSP SqlDwUnifiedDatabaseSchemaProvider.

During testing, sometimes might notice that Visual Studio defaults to creating an Azure Synapse Serverless SQL project instead. In such cases, you can open the .sqlproj file in a text editor and manually update the DSP value to the correct one for Fabric Data Warehouse:

<DatabaseSchemaProvider>Microsoft.Data.Tools.Schema.Sql.SqlDwUnifiedDatabaseSchemaProvider</DatabaseSchemaProvider>

To avoid the platform mismatch error in Schema Compare, make sure:

Visual Studio is updated to the latest release: Visual Studio 2022 Release Notes | Microsoft Learn
SQL Server Data Tools (SSDT) is installed or up to date:Install SQL Server Data Tools (SSDT) - SQL Server Data Tools (SSDT) | Microsoft Learn
Both the source project and the target are set to the same platform

Once these are in place, Schema Compare should work as expected.

Some Useful resources: SQL Projects Target Platform - SQL Server | Microsoft Learn

Schema Compare Extension - Azure Data Studio | Microsoft Learn

Hope this helps. Please reach out for further assistance.

If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.

Thank you.

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

v-veshwara-msft — Mon, 16 Jun 2025 07:21:38 GMT

Hi MaciejUrbaniak ,

Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries.

Otherwise, feel free to reach out for further assistance.

Thank you.

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

MaciejUrbaniak — Mon, 16 Jun 2025 07:32:22 GMT

Hi v-veshwara-msft,

It did help but did not resolve all problems. So when chosing SqlDwUnifiedDatabaseSchemaProvider (BTW, the standard SQL Projects do not have such options available in GUI so the change must be done directly in the .sqlproj file), the Schema Compare works but it SqlDwUnifiedDatabaseSchemaProvider is not fully compatible with the Fabric Warehouse, the build command results in some errors like scalar functions are not supprted by the target. But when I create such function diretly in Fabric, it works. So the SqlDwUnifiedDatabaseSchemaProvider target is not 100% correct one.

I found another target in the docs SqlDbFabricDatabaseSchemaProvider but I haven't been able to test it yet as it requires installation of SQL Server Data Tools SDK style.

I will update this thread once I get this extension installed

Best regards,

Maciej

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

MaciejUrbaniak — Mon, 16 Jun 2025 14:36:22 GMT

This thing is seriously broken, SSDT and SSDT SDK Style connot coexits (VS installer does not inform about it when SSDT SDK Style is chosen for installation). Obvious solution would be to uninstall SSDT. Then everything else breaks... I need to reinstall whole VS2022... What a waste of time.

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

v-veshwara-msft — Tue, 17 Jun 2025 12:39:43 GMT

Hi MaciejUrbaniak ,

Thanks for sharing your observations. Sorry to hear about the issues - the tooling for Microsoft Fabric Data Warehouse projects in Visual Studio is still evolving.

The SDK-style SQL projects are still in preview and, as noted in the official documentation, they come with some limitations. These include lack of support for schema compare, table designer, data comparison, unit testing, and SQLCLR objects. Side-by-side installation with classic SSDT projects is also not supported. In Visual Studio 17.12 Preview 2, these projects use the .sqlprojx extension, which switches back to .sqlproj in Preview 3 and later.

If you're considering trying the SDK-style approach, existing SQL projects can be converted. Microsoft supports in-place conversion to SDK-style using the Microsoft.Build.Sql format. It’s recommended to create a backup before doing this. The official guidance outlines the steps to convert the project manually.

Convert an Original SQL Project - SQL Server | Microsoft Learn

Regarding scalar functions, they are currently build with errors in Visual Studio but do work when created directly in Fabric. Microsoft has shared that scalar UDFs are now available in private preview, which may explain the difference in behavior. You can find more details in this blog post: Another dimension of Functions in Data Warehouse | Microsoft Fabric Blog | Microsoft Fabric

Apologies for the inconvenience this has caused, and thank you for continuing to test and share your findings - it’s helpful for others facing similar challenges.

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly.

Thank you.

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

v-veshwara-msft — Fri, 20 Jun 2025 06:55:59 GMT

Hi MaciejUrbaniak ,
As we haven't heard from you, just checking in to see if the above response was helpful. If yes, please consider marking it as Accepted Solution to assist others with similar queries. If further assistance is needed, please reach out.
Thank you.

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

v-veshwara-msft — Tue, 24 Jun 2025 06:35:29 GMT

Hi MaciejUrbaniak ,

May I ask if the response provided has been helpful? If so, please consider marking it as Accepted Solution to help others with similar queries.

If you need any further assistance, feel free to reach out.

Thank you.

Re: Which Target Platform in VS2022 for MS Fabric DWH project?

R1k91 — Thu, 26 Jun 2025 11:51:36 GMT

Hi MaciejUrbaniak I blogged about this situation some months ago (something has changed in the meantime, for example schema compare is now available).

https://medium.com/riccardo-perico/azure-data-studio-is-dead-and-now-b5a57139b2d5

The most mature version of DBproj for Fabric is in Azure Data Studio that is discontinued.

At the moement Visual Studio doesn't support them.

You should go with Visual Studio Code but many aspects are WIP or not even started.

Microsoft PMs said that they'll work to include the support in Visual Studio also but there's no ETA, as far as I know.