December 24, 2012

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

Executing the Schema Compare in Visual Studio 2012, I get the error message "A project which specifies SQL Server 2012 as the target platform cannot be published to SQL Server 2008."


This error occurs because in Visual Studio 2012 the target platform of the database project is by default set to SQL Server 2012 and your database to be compared does not match the setting. If your target database is SQL Server 2008 like me for example, you can follow the below steps to change the target platform.
  1. Right-click on the project name in Solution Explorer and click Properties.
  2. Click the Project Settings tab.
  3. Change the target platform from SQL Server 2012 to SQL Server 2008.
  4. Save the project and execute the Schema Compare function again.

4 comments:

Kayal m said...

great job! The author giving the present post, this is very unique and worthy content. I am waiting for your another post...

Oracle Training in Chennai
Oracle Training institute in chennai
Tableau Training in Chennai
Spark Training in Chennai
Unix Training in Chennai
Power BI Training in Chennai
Oracle DBA Training in Chennai
Oracle Training in Chennai
Oracle Training institute in chennai

jenifer irene said...

It was really an interesting blog, Thank you for providing unknown facts.
aviation institute in Chennai
Air Hostess Training Institute in Chennai
Airline Courses in Chennai
ground staff training in Chennai
Aviation Academy in Chennai
air hostess training in Chennai
airport management courses in Chennai
ground staff training in Chennai

sandeep saxena said...

I really enjoyed this article. I need more information to learn so kindly update it.
clinical sas training in chennai
SAS Training in Chennai
sas training fees in chennai
sas course fees in chennai
sas course fees
Placement Training in Chennai
soft skills training in chennai
core java training in chennai

cynthiawilliams said...

Well written post with worthy information. It will definitely be helpful for all. Do post more like this.
Ethical Hacking course in Chennai
Ethical Hacking Training in Chennai
Hacking course
ccna course in Chennai
Salesforce Training in Chennai
Angular 7 Training in Chennai
Web Designing course in Chennai
Ethical Hacking course in Thiruvanmiyur
Ethical Hacking course in Porur
Ethical Hacking course in Adyar