how to upgrade sqlproj,dtproj file to SDK style?

Question

The solution has csproj and sqlproj (dtproj) files. Projects targetframework is 4.6.2 want to upgrade it .net8.0. Using upgrade-assistant upgrade csproj file . Should I upgrade sqlproj file also ? and if yes How I can do that? Any documentation . Thanks

Answer 1

Hi @namiq genciyev , Welcome to Microsoft Q&A,

Using the .NET Upgrade Assistant is the recommended way to upgrade your .csproj files. The tool will handle most of the complexities involved in migrating your C# projects to .NET 8.0.

SQL Server Data Tools (SSDT) projects (.sqlproj or .dtproj) do not target a specific .NET framework version directly.

Make sure your SSDT version is compatible with a version of Visual Studio that supports .NET 8.0. In general, newer versions of Visual Studio will support the latest .NET version. Ensure that any tools or scripts used to build and deploy your database project are compatible with the environment in which your .NET 8.0 project will run. Make sure you're using the latest version of Visual Studio that supports .NET 8.0 and SSDT projects. Visual Studio 2022 is a great choice because it supports the latest .NET versions and SSDTs.

Build and test your .sqlproj to make sure your project is okay after upgrading your environment.

This type of platform upgrade is not guaranteed to be error-free, and you will need to correct it on a case-by-case basis based on the error message.

Overview of the .NET Upgrade Assistant

Download SQL Server Data Tools (SSDT) for Visual Studio

Best Regards,

Jiale

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.