SQL database Project : A project which specifies SQL Server vNext CTP as the target platform cannot be published to SQL Server 20016

“A project which specifies SQL Server vNext CTP as the target platform cannot be published to SQL Server 20016.”

I recently encountered the above error message while publishing or generating SQL script from database project.

After getting this error, I investigated and found that database project’s Target Platform was SQL Server 2017 and Target SQL Database is SQL Server 2016 version and followed to below steps to resolve this incompatibility issue.

Step 1: Click on Advanced Button

Step 2: Advance Publish Settings à General Tab à Check “Allow incompatible platform” option under Advanced Deployment Options

Step 3: Click on Generate Script Button and your SQL script is successfully generated

Thanks for visiting !!