Allow incompatible platform in schema comparison

Posted on June 4, 2014 by erictummers

Schema comparison of SQL Express 2012 database and SQL Server 2008 gives an error

A project which specifies SQL Server 2012 as the target platform cannot be published to SQL Server 2008.

Set the allow incompatible platform in the options (little gear icon) and you’re good to go.

Saving the comparison to a file (.scmp) will include this setting. No more complaints about versions.

About erictummers

Working in a DevOps team is the best thing that happened to me. I like challenges and sharing the solutions with others. On my blog I’ll mostly post about my work, but expect an occasional home project, productivity tip and tooling review.

View all posts by erictummers →

This entry was posted in Tooling and tagged sql server data tools, sqlserver. Bookmark the permalink.

2 Responses to Allow incompatible platform in schema comparison

Thankful Person says:

January 7, 2016 at 5:03 pm

THANK YOU! Changing the target platform in my project didn’t work, but this did, very cool!

Reply
Kenneth says:

August 17, 2016 at 11:21 pm

Thanks too from me.
Just as Thankful Person said, changing the target platform did not work, nor did changing the compatibility level in the databse.

Reply