CODEWITHSUNDEEP
sql-servervisual-studiovisual-studio-2013azure-sql-databaseschema-compare
Johnny Oshika
Johnny Oshika

Reputation: 57502

SQL Server / SQL Azure Schema Compare

I'd like to compare schemas between SQL Server 2012 and SQL Azure, but I get this error in Visual Studio 2013:

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

enter image description here

Is it possible to compare these 2 database types?

Upvotes: 30

Views: 6652

Answers (3)

Atchitutchuk
Atchitutchuk

Reputation: 184

Need more reputation to comment, sorry for redundant answer: this window can not be found in VS options. Start comparison and click options button enter image description here

Upvotes: 4

Corillian
Corillian

Reputation: 917

There actually is a non-cumbersome method to overcome this problem. Just open up the schema compare options and make sure the "Allow incompatible platform" box is checked

SQL Compare Options - General

Upvotes: 71

Anthony Chu
Anthony Chu

Reputation: 37520

The only way I've been able to do this is to import the SQL 2012 DB to a database project targetting SQL Azure, then compare the project to the SQL Azure database.

Upvotes: 1

Related Questions