Allow incompatible platform in schema comparison

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.
This entry was posted in Tooling and tagged , . Bookmark the permalink.

2 Responses to Allow incompatible platform in schema comparison

  1. Thankful Person says:

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

  2. Kenneth says:

    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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.