sql: Error: Deploy72002: A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to SQL Server 2019.

  • The Deploy72002 error: Because your SQL Server Database Project targets SQL Server 2022 or Azure SQL Database Managed Instance, you cannot publish it to SQL Server 2019. A version discrepancy causes deployment compatibility concerns.
    • Modify the Target Platform in Visual Studio
    • Open your SQL Server Database Project in Visual Studio.
    • Right-click on the project in the Solution Explorer and select Properties.
    • Navigate to the Project Settings or Configuration Properties.
    • Locate the Target Platform setting.
    • Change the target platform to SQL Server 2019.
    • Save the changes and rebuild the project.

 

 


Related Question