Menu
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.
Is it possible to compare these 2 database types?
907
On the Tools menu, select SQL Server, and then click New Schema Comparison. Alternatively, right-click the TradeDev project in Solution Explorer, and select Schema Compare. The Schema Compare window opens, and Visual Studio automatically assigns it a name such as SqlSchemaCompare1 .
Azure SQL Database offers Database-as-a-service (DBaaS-PaaS). With SQL Database, you don't have access to the machines that host your databases. In contrast, Azure Virtual Machine offers Infrastructure-as-a-service (IaaS). Running SQL Server on an Azure VM is similar to running SQL Server in a On-Premise datacenter.
Since Azure SQL is based on SQL Server, they share many similarities in functionality and compatibility. But that doesn't mean they are the same. In fact, contrary to what many think, Azure SQL is not exactly the cloud version of SQL Server because there are many fundamental differences between the two.
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
174
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
