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.

allow.incompatible.platform

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

About erictummers

My work as a recruited developer changes almost every month. 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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s