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.

allow.incompatible.platform

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:
    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
  2. 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

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Cancel

Connecting to %s

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