JohnIn a nutshell – either update the target platform of the SQL database project to match database reference or vice versa; update the version of the database reference to match project.
In all honesty, a lot of the errors I encounter are self-explanatory but I suppose I get so frustrated with an error in general I just look over it. But anyway, have you tried to add a database reference to a SQL project and get an error like something below?
This error is saying that your project version and database reference(s) version do not match. So you have to either update the reference or the project so that the two match – whichever you think is best for your project. In the example I show below, I am going to show both cases; one which I need to update the SQL project, and the other where I need to update the master database reference.
In the left image, I added a reference to centraldba_db, but I got the error message from the initial image in this post. So I decided to update the target platform from SQL Server 2008 to SQL Server 2014 like below:
Once I did that, centraldba_db referenced fine, but my master reference has the same issue. Because I updated my target platform to SQL Server 2014, I had need to update the master reference to that version as well.
So I deleted the one in Solution Explorer and then referenced the one here “…\SqlServer\120\SqlSchemas\ma
Now all my references work as they should:
